Timezone in action flow and ROUND_DAY function

Hi,

I'm implementing an AF with some volumes.

I query two columns:

In the first column there is a date rounded by day, and the second column is the count.

I noticed that the ROUND_DAY function applied to the first column is not working fine, since it keeps the timestamp, putting everything to 0 (2022-03-27T00:00:000Z). The problem is that at the 27 of march I have two dates that are the same, one with all 0 in timestamp, the other with 23 at the beginning. This is because at the 27 of march the time is changed by one hour, and it just mess everyting up the in AF.

In the dashboard everything is working fine, since the ROUND_DAY function allow me to display only the date without timestamp (2022-03-27).

How can I fix this in the AF?

already tried:

YEAR(date) || '-' || MONTH(date) || '-' || DAY(date), same as before

formatDate function in AF: it says that the date is not a valid date.

Thanks

Page 1 / 1

So here is what you need to do , try pasting the following in your action flow, replace the date part with the column value.

{{formatDate(substring("2022-03-27T00:00:000Z"; 0; 10); "MM/DD/YYYY")}}

Hope this helps!

So here is what you need to do , try pasting the following in your action flow, replace the date part with the column value.

{{formatDate(substring("2022-03-27T00:00:000Z"; 0; 10); "MM/DD/YYYY")}}

Hope this helps!

PS: May have got the format you wanted wrong

Thank you very much for your reply, but it's not working.

I'm replacing the string with table.column, and it consider table.column a string itself, so it cuts the name of the table out and it throws the error that is not a valid date.

Thank you very much for your reply, but it's not working.

I'm replacing the string with table.column, and it consider table.column a string itself, so it cuts the name of the table out and it throws the error that is not a valid date.

Use the function where you are filtering or doing the action, i.e let query data get the data and post that use the function.

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN