AnsweredAssumed Answered

fn-FormatDate doesn't work with specific regional settings

Question asked by lehuspohus on Jun 7, 2017
Latest reply on Jun 19, 2017 by lehuspohus

Hi!

I have a DateOnly field in standard SP list, which contains date: 13.10.1988, for example
SPWeb (where my list located) have UTC+7 timezone in site regional settings (/_layouts/15/regionalsetng.aspx)
So, the UTC value in database looks like:

<datetime1>1988-10-12T16:00:00</datetime1>

Next, in workflow I'm getting date field from SQL database (using Execute SQL action) which is "date" type, looking like a '1988-10-13' and then I save it to Nintex Date and Time variable.

 

And finally, I'm trying to compare (using Set a condition action) this two dates: list date vs SQL date, which are obviously equal:

condition looks like:

It worked nice:

until I've changed my user regional settings from Russian (locale 1049) to English (USA, locale 1033) and tried to re-run workflow under this user account

I discovered that inline FormatDate function doesn't work anymore:

It looks like Nintex doesn't recognize its own inline functions and trying to compare text strings which is different.

 

Then I tried the same comparsion but without fn-FormatDate, just compare two variables, one from SQL, second from item.

And realized that in both cases (locale settings) I got result that these dates are different.

LCID 1049:

   

LCID 1033:

   

 

 

I do not understand now at all how Nintex performing dates comparing. Please help me for get this to work correct )

Outcomes