DATEADD basic funktion is missing

Hello community

I wanted to know how to subtract an end date with the duration in seconds to get the start date.
Here is the synthax I use DATEADD(interval, number, date). But I systematically get an error. This function is a SQL standard. This function is a basic ETL function, like : Qlik, Talend…

Is there an Easymorph method, without having to use SQL?

Hi,

If your duration is in days :
[end date] - [duration]
if your duration is in seconds (“duration(s)”) then
[end date] - ([duration]/86400)
date and time are stored as real, date is just a formatting

Regards

2 Likes