Differense between two dates

Hello. I have a planned processing date for the order “CASES_SHOP”. “DATENORM”, and an actual processing date for “CASES_SHOP”. “DATEPOST”.

“CASES_SHOP”. “DATENORM” - 20190929
“CASES_SHOP”. “DATEPOST” - 20200830

DAYS_BETWEEN ( “CASES_SHOP”.“DATEPOST” , “CASES_SHOP”.“DATENORM”) - it doesn’t work.

Please tell me how can I calculate the difference between them?

Hi @Radamir96,

are these to columns “CASES_SHOP”. “DATENORM” and “CASES_SHOP”. “DATEPOST” defined as timestamps? I assume they are defined as STRINGS.
In case they, you have to use the function TO_TIMESTAMP to transform your STRINGS into timestamps.

Best,

Justin

1 Like

It’s all right!

Thank you very much!