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

Created item date value increased with two hours

Hi,

I have an issue and it seems I can't find a general solution.

I need to report some timestamps regarding Workflow Tasks for specific workflows. After each Task, using the Task ID I query the Workflow Task list and save the Created and Modified dates into variables. If I write these variables then into WF history log, the date is correct.

But after that I want to create a new Item into a "Report" list in which I store this dates too from the variables. For some reason in the list teh created Item's value is 2 hours more then it was in the variable...

I use this action at least 50 places across multiple workflows... 

Server times are correct.

We are in UTC+2, Time Zone, maybe that's the key but I don't know how to modify easily, without changing everywhere the workflows.

Any idea?

Thanks in advance!

Robert

Labels: (2)
0 Kudos
Reply
11 Replies
tbeduneau
Nintex Newbie

Re: Created item date value increased with two hours

Maybe something to do with Sharepoint site regional settings : check if Time Zone and Regional Settings are correct.

For example if you set TimeZone to UTC+2 but set Locale to Japan, this could cause some issues.

Reply
rszabo
Nintex Newbie

Re: Created item date value increased with two hours

Unfortunately, that's correctly configures. This was my first idea too, then server time...

Reply
Nintex Employee
Nintex Employee

Re: Created item date value increased with two hours

Hello Szabó Róbert​ -

This may not be the best solution, but for the now, what about doing a calculation and subtracting 2 hours? If this is the case for ALL ITEMS, this may get you through until it is resolved.

Reply
rszabo
Nintex Newbie

Re: Created item date value increased with two hours

Thanks, I had the same idea of workaround, but I have to change it then in 100+ places across multiple workflows. Of course I can do it, but the issue itself bothers me in general...

Reply
bcobra
Nintex Newbie

Re: Created item date value increased with two hours

I am having the same issue. In the workflow the value is correct but when it goes to update the list it is subtracting 4 hours from the time making it UTC+-0.

Reply
rszabo
Nintex Newbie

Re: Created item date value increased with two hours

Well, I couldn't solve the mystery. If you find anything please share. Good luck!

Reply
bcobra
Nintex Newbie

Re: Created item date value increased with two hours

I am running 3.5.1 nintex said it was fixed in 3.6.1 what version are running

Reply
rszabo
Nintex Newbie

Re: Created item date value increased with two hours

We have 3.5.1 too, I think we installed last September, since then I couldn't dare to upgrade

0 Kudos
Reply
mzi
Nintex Newbie

Re: Created item date value increased with two hours

We have had the same issue with a few farms. I would recommend using a global UDA for such calculations, in that case you could change the date calculation easily across the whole farm if the need should arise.

0 Kudos
Reply