Convert UDT to CEST with DST

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.

Developer

Developer Tools

Date Time

Common Use Cases

Best Practices

Preparation

Accepted answers

All comments

Luke_C

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.

apathetichell

@Luke_C - I had vague memories of seeing this but had to look back to the DateTime page:

DateTimeToLocal

DateTimeToLocal(dt): Converts a UTC date-time to the local system time zone.

Parameters

dt: Date-time data expressed as a selected column or a specified date-time value between quotes.

Examples

DateTimeToLocal('2014-08-01 20:01:25') returns the local system time zone (Mountain Time) as 2014-08-01 14:01:25.

DateTimeToUTC

DateTimeToUTC(dt): Converts a date-time (in local system time zone) to UTC.

Parameters

dt: Date-time data expressed as a selected column or a specified date-time value between quotes.

Example

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).

Luke_C

@apathetichell good call!

RonGatmaitan

Hi, @apathetichell. How is Alteryx supposed to know where "local" is? Not sure that local = CEST.

apathetichell

DateTimeFormat(datetimenow(),"%Z")

Alteryx takes your system time. you can reconfigure your system to CEST if its not CEST and then run your workflow.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335