Michele
Scholar

Workflow Context Current Date populates item with Yesterday's date

Jump to solution

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?

Labels: (1)
0 Kudos
Reply
2 Replies
butlerj
Community Manager
Community Manager

Re: Workflow Context Current Date populates item with Yesterday's date

Jump to solution

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

0 Kudos
Reply
Michele
Scholar

Re: Workflow Context Current Date populates item with Yesterday's date

Jump to solution

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

 

 

 

Reply