Issues with dates in scheduled workflows

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: 

  1. Our preferred date format is dd/MM/yyyy and logging the variable that contains the date returns it like this. However, when a notification is sent out it gets converted to MM/dd/yyyy and takes off 1 day. E.g. 20/06/2019 becomes 06/19/2019. The notification action comes right after the log action in WF so I wouldn't expect it to be changing.

  2. Using query list to filter out items if due date has passed current date is causing workflows to terminate with the following message: "String was not recognized as a valid DateTime".
    Due date is a sharepoint column as a Date and time
    Current date is done by using Add time to date action storing result in a Date/Time variable:

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.



Best answer by toms 10 July 2019, 23:24

View original

2 replies

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