Hi all,
Has anyone implemented this already. UDT to CEST is basically plus 2 hours but, considering DST, sometimes it's 3 hours.
As far as I know, DST is effective every last Sunday of March to last Sunday of October.
I'm looking for the simplest way to implement this.
Thank you.
Do you have some sample data? I'd imagine it would be some form of an if statement to check the DateTimeToday() against the range of daylight savings times and then uses a DateTimeAdd() formula to update the time accordingly.
@Luke_C - I had vague memories of seeing this but had to look back to the DateTime page:
DateTimeToLocal(dt): Converts a UTC date-time to the local system time zone.
dt: Date-time data expressed as a selected column or a specified date-time value between quotes.
DateTimeToLocal('2014-08-01 20:01:25') returns the local system time zone (Mountain Time) as 2014-08-01 14:01:25.
DateTimeToUTC(dt): Converts a date-time (in local system time zone) to UTC.
dt: Date-time data expressed as a selected column or a specified date-time value between quotes.
DateTimeToUTC(DateTimeNow()) returns the Coordinated Universal Time at workflow runtime: 2014-08-01 20:01:25 (where local Mountain time was 2014-08-01 14:01:25).
@apathetichell good call!
Hi, @apathetichell. How is Alteryx supposed to know where "local" is? Not sure that local = CEST.
DateTimeFormat(datetimenow(),"%Z")
Alteryx takes your system time. you can reconfigure your system to CEST if its not CEST and then run your workflow.