Question
I want to check if the delivery date is less or equal to today's date + 42 days - WHEN TO_DATE("EKES"."EINDT", FORMAT ('%d-%m-%Y)) <= ADD_DAYS(TO_DATE(TODAY(), FORMAT('%d-%m-%Y)), 42) THEN 'Relevant' ELSE NULL END // There is always a syntax
+6I want to check if the delivery date is less or equal to today's date + 42 days -
WHEN TO_DATE("EKES"."EINDT", FORMAT ('%d-%m-%Y)) <= ADD_DAYS(TO_DATE(TODAY(), FORMAT('%d-%m-%Y)), 42) THEN 'Relevant' ELSE NULL END // There is always a syntax error.
+5https://docs.celonis.com/en/add_days.html
CASE WHEN "EKES"."EINDT" <= ADD_DAYS(TODAY(),42) THEN 'Relevant' ELSE NULL END
From your query, the syntax error seems to come from the FORMAT() function, you do not seem to be closing the quotation " ' ".
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.