cancel
Showing results for 
Search instead for 
Did you mean: 
Automation Master
Automation Master

Re: Date field "losing a day" when creating item

good shout ‌.  Using on-prem 2013 3.2.3.2

0 Kudos
Reply
Automation Master
Automation Master

Re: Date field "losing a day" when creating item

Hello Mike Matsako‌ – thanks for the suggestion! I've confirmed the issue isn't spawning from default values, and it looks like Cassy Freeman‌ and I are using the same version of workflow.

I have reproduced the issue in more than one SP2013 environment, so I don't think this is a false positive involving user error. That said,Cassy Freeman has confirmed for me that Nintex UK > Nintex USA.

Reply
jeffvojtko
Nintex Newbie

Re: Date field "losing a day" when creating item

Odd as it sounds; I seem to have viewed a time difference of about four hours between servers. And, I am wondering if that difference impacts this at all. I am having the same problem. A date only is one thing in one list and one day less in the other. I know Sharepoint and Nintex treat the date as midnight of the first day. I wonder if somehow that four hour difference is impacting.

Reply
jeffvojtko
Nintex Newbie

Re: Date field "losing a day" when creating item

I noticed in the workaround that you calculate your date in Local time vs UTC which for us is a four hour difference.

I think nintex may by default store in UTC...

Reply
Automation Master
Automation Master

Re: Date field "losing a day" when creating item

Jeff Vojtko‌ – what's odd here is we're never leaving the context of this site collection (two lists in the same site). It's got to be something with translation from SP column to nintex wf variable and back to SP column.

0 Kudos
Reply
Automation Master
Automation Master

Re: Date field "losing a day" when creating item

Jeff Vojtko‌ – ah good catch! Let me test a variation using UTC.

Reply
kmccool
Nintex Newbie

Re: Date field "losing a day" when creating item

I'm having the same issue. I think maybe I'll just add a day with the workflow so when it creates the item it's the correct date.

Patrick Abel‌, were you able to resolve the issue or did you use a similar work around?

Thanks

Kassie

0 Kudos
Reply
Automation Master
Automation Master

Re: Date field "losing a day" when creating item

Hello Kassie,

I was able to resolve this issue by adding a "Add time to Date" action that doesn't actually manipulate time in the variable. I didn't add any days, hours, minutes, etc. to the date variable, but simply including this action and re-set the date to the same variable.

This resolved the one day off issue for me (I've seen this a time or two with clients).

Reply
harfmt
Nintex Newbie

Re: Date field "losing a day" when creating item

Time is: Local - not in 365 configuration

0 Kudos
Reply