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 )