I am in Arizona (GMT-7). In my workflow, I am using the Context variable, Current date, to populate a Date column in SharePoint Online item. "Include Time" is set to No on the column. There is no default value for that column.
Today is 8/13/2021. The workflow is setting the date in my SharePoint list to 8/12/2021.
Why would this be happening? Does anyone have a workaround for this?
Best answer by Michele
View original
+19
@Michele if you log the 'current date' variable in your workflow does it show the right date? I suspect this is because when it gets posted to SPO it's getting sent in YYYY-MM-DDT00:00:00.00Z format which is then getting interpreted by SPO as GMT, but would be good to confirm.
@butlerj - Thank you for responding so quickly!
I added the current date variable to my log, and it is correct: 2021-08-03.
Based on your suggestion, I changed the variable I am assigning to my SPO Item Column from "Current Date" to "Current Date and Time".
That fixed the issue. My SharePoint Item now displays 8/13/2021.
Thank you!
P.S. This was my first post in the Nintex Community and it was so good to get an answer this quickly.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
