Calculate date action returns different ISO 8601 value for Nintex Workflow 2013 and 2016

  • 6 August 2019
  • 2 replies
  • 34 views

Badge +1

Hi,

 

Currently we are using both Nintex workflow 2013 for SharePoint on-premises 2013 and Nintex workflow 2016 for SharePoint on-premises 2016.

Recently, we've found one issue with the "Calculate date" action. Seems that this action is returning different ISO 8601 date value for Nintex 2013 and Nintex 2016.

 

This issue can be replicated by creating the following workflow (In both Nintex workflow 2013 and 2016):3845i311A68280E40AE91.png

Calculate date (Time = “UTC”) action:

3846iFED01BA4DAFBA39C.png

 

Calculate date (Time = “Local”) action:3847i961F7AF630F25A37.png

 

And log in history list action:3848i67319CFF08139D95.png

Results:

 

  • In Nintex 2013:3849i099FDA937DCCFCA1.png

     

 

  • In Nintex 2016:

3850iA967AB1039B57F46.png

             

So we have some queries below:

 

  1. ISO 8601 date string (Time = Local) is 2019-08-06T10:12:54Z in Nintex 2013 for but it is 2019-08-06T02:12:59Z in Nintex 2016. Could anyone can advise on this? Is it a bug or there are some settings that can impact on this action?
  2. Besides that, we also would like to check why in Nintex 2013, Calculate date action returns same ISO 8601 date string for both “Local” and “UTC”

 

Below is the version information and locale settings:

 

Nintex workflow 2013:

  • Version: 3.2.5.0 – English
  • License type: Enterprise

 

Nintex workflow 2016:

  • Version: 4.4.1.0 – English
  • License type: Enterprise

 

Server's locale settings time zone: (Same for all SharePoint servers and all site collections (regional settings), the account which is used to test also has same time zone in personal setting).

  • (UTC + 08:00) Kuala Lumpur, Singapore.

 

Thanks & Regards

 


2 replies

Userlevel 6
Badge +22

Hi,

Your 2016 results are correct and your 2013 results are not correct.
ISO 8601 is a way to state a date and time in a format that is universal.
The date and time used is always UTC,ZULU,GMT what ever you want to call it.
In the first action you are saying I am giving you a time and that time is in UTC. As ISO 8601 is also in UTC no changes are made to the time when it is output.

Next action is saying. I am giving you a time and that time is the local time now give me the ISO 8601 time. A conversion is made and a time which is 8 hours behind KL time is returned GMT +8 which is correct.

 

You are on an very old version of Nintex workflow for 2013.  My testing on the latest version gave me the same results as 2016.

Badge +1

Hi SimonMuntz,

 

Noted with thanks for the explanation.

 

Thanks & Regards,

Reply