Context: I've been tasked to start migrating our workflows over to O365 from 2013 ahead of time to hopefully make the transition smooth. Our environment is based in NZ with a timezone of (UTC +12).
I'm having two issues with dates within scheduled workflows and hope they might be caused by the same thing:
Regional settings in the site are configured to our local time (NZ UTC+12) and have quadruple checked it at this point - I've tried changing to US to see if this solves it but both issues still occur. Also these issues only occur in scheduled workflows.
If anyone has any idea on how to solve either of the above issues I would love to hear them.
Solved! Go to Solution.
All dates in SharePoint Online (Office365) are saved in UTC+0 format.
In the interface Microsoft transforms these dates to your region settings.
In your case the add 12 timezones to it.
Try out your actions with UTC time.
If you need to display the date in like e-mails with dd/MM/yyyy.
We split the date on / Put it in a collection. And rebuild the date in a variable in different order for displaying in like emails.
Thanks for the reply. What I ended up doing was storing the Date as a GUID in a text variable and modifying it from there. Storing as a GUID solved both of my problems