Hi all,
I would like to change the date and time of various time zones in the data for performing the review easily, for example: 11/3/2017 4:15 PM AWST. The AWST here stands for Australian Western Standard Time, and I would like to covert it to local time - Hong Kong time. Is it possible please?
Many thanks in advance,
Jenny
Solved! Go to Solution.
Alteryx only has UTC to local datetime conversions built in, but you can use DateTimeAdd() to adjust for the difference in hours between known time zones. However, in your case Hong Kong is in the same time zone as AWST so this shouldn't be necessary.
Thanks Sruhl, good to know that there is way to get that work.
Is DateTimeAdd() a function in Formula or it's within Date/Time parse function? Would you mind to show me in work flow on how to use this function for my data format?
Many thanks,
Jenny
Sure thing @Jennyman130. Please see the attached workflow.
Thanks so much all, but I got an error message saying the sample is a newer version of Alteryx, so I can't view it. :(
Is it possible to post as a screenshot please?
Many thanks,
Jenny
Handy trick.
You can downgrade a workflow by opening it up in a text editor and amending the version (outlined in line 2), to 11.5 for instance.
Ben
Sorry I tried to open it with a notepad, but the second line is like below. Doesn't seem quite like the format you mentioned.
<AlteryxDocument yxmdVer="2018.1">
right yes, so you can simply overwrite 2018.1 to 11.5 or the correct version number and then save it.
Then you will be able to open the workflow.
ben