formatDate doesn't work well when i use backslash(/) - Australian time zone

  • 17 March 2020
  • 5 replies
  • 23 views

Badge +3

Hi All,
I have setup a variable called ftDate and use the forumular below

formatDate(IncidentDateTime, "dd-MM-yyyy")
When i use dd-MM-yyyy i get the correct output e.g 10-12-2020
But when i use dd/MM/yyyy I get Fri December 2020 Australian time bla bla..
 

Why is this?
I need the format like this 10/12/2020

Thanks in advance


5 replies

Userlevel 6
Badge +22
Hi,

Please provide more information about this issue.
What build of Nintex Workflow are you using?
Are you using a build string action with the format date inline function or something else?
Badge +3

Hi Simon,


I think i have provided more info on this.


See variable screenshot


The original filed i'm coverting is just a date field- Date and Time


Does this make sense?


Userlevel 6
Badge +22
Ok. You posted in the Nintex for SharePoint section but your screen shot is for Nintex for O365 so i have moved the post accordingly.

It appears you are using Nintex Forms variables and not workflow as i first thought so this is why I need more information.

I tested this functionality and it is working as expected.
make sure that your Nintex Forms app is up to date on O365.
Badge +3
THanks No worries.
Can you please send me the link to the new post you moved to Nintex Office 365.
Also what latest version should i be using to get this workin?
Userlevel 6
Badge +22
There is no new post. I moved the whole thread to the correct category.

Go to site contents n classic mode. Look for the Nintex forms app and see if there are any messages advising an update is available. This may not be the issue but its a start.

Reply