Extract date only from app_info.current date and time

1

Hello,
I have a Tulip table that contains lot of data on of the fields contains Current record date and time.
I created a query that should filter all records of a specific date from midnight to shift end time (6am or 15pm or 23pm).
The query depends on an application variable.
I want to set this variable to have the value of current date but the hour should be 00:00:00, what is the exact expression I should put in the data manipulation command ?

Thank you,
Regards,
Amit Berku

2

you could do Date_Trunc_TZ(App.Info.Current Date and time, “day”, “Your Time Zone”) this will return the current day at 00:00:00. You could then save that to a variable to use for filtering.

3

Thank you @jla , it’s working great !!!