cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

When I create an update a Date and Time workflow with set field value it always defaults to 12:00AM

Hello,

 

I have been trying to create a workflow that is to update a date and time column in a list when a certain status from another column is chosen. I want the workflow to update the date and time column with the current date and time when a certain status is chosen. I was able to get a workflow put together but it saves correctly the first time and the second time when I save the item again it keeps defaulting the time to 12:00AM. The date portion works well. I tried the "Calculate Date" function, I have tried to build a date and time string and I have tried changing things in SharePoint. I have it set to only run on an item once. I have attached pictures of the first save and the second save below.

 

If anyone has ideas on what kind of workflow would stop this from happening please let me know. Any help is much appreciated! Thank you in advance!Status Active Date 1.PNGStatus Active Date 2.PNG

Labels: (2)
0 Kudos
Reply
2 Replies
Highlighted
Nintex Newbie

Re: When I create an update a Date and Time workflow with set field value it always defaults to 12:0

In your workflow choose the action "Set Field Value"

Choose your Status Active Date

In the value field drop down select Workflow Context > Current Time

Your List Column must be set to Date/Time for this value to work otherwise you will get a workflow error that they type of data you are trying to enter doesn't match (in which case you should use Current Date). 

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: When I create an update a Date and Time workflow with set field value it always defaults to 12:0

@missbrad Thank you so much for your advice! For some reason it still works the first time I save the item but the second time I save it it defaults back to 12:00 AM. I have it set not to run again on this item with conditions. I'm not sure if it's something with how Nintex is talking to SharePoint, just Nintex or just SharePoint? 

Current Time Test.PNGSet Field Value.PNG

0 Kudos
Reply