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 | Community

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 error.

Page 1 / 1

https://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 " ' ".

Reply