Hello everyone,
I have been trying to find a post about changing the date format in Nintex forms: from the default one mm-dd-yyyy to dd-mm-yyyy. Is there any option on Forms how to do this?
Thank you in advance
Format Date from mm-dd-yyyy to dd-mm-yyyy
+3
You can use the function formatDate(datetime value, format).
For example:
formatDate(dtDateTimeVariable,"DD-MM-YYYY")
Alternatively, Nintex uses the Tenant default that your global admin may change (of course this affects everyone everywhere)
For example:
formatDate(dtDateTimeVariable,"DD-MM-YYYY")
Alternatively, Nintex uses the Tenant default that your global admin may change (of course this affects everyone everywhere)
+3
Thank you @v-tmasenko for your reply. I tried the following and it did not work. I wouldnt be able to decide for everyone so the Default value i cannot change. can you tell from the screenshot what am i doing wrong? thanks
More specifically the Tenant default I was referring to is known as "Office 365 sites regional settings".
You can confirm this by going within Nintex for O365 Form Settings-->Regional Settings. You'll see the Region field that indirectly identifies the date and time format.
For example, English (United States) short date is mm/dd/yyyy
Each country/language has a short date format default pre-defined.
So your global admin would need to select the country/language that is appropriate for your organization (and, of course, have previous approval/communication)
You can confirm this by going within Nintex for O365 Form Settings-->Regional Settings. You'll see the Region field that indirectly identifies the date and time format.
For example, English (United States) short date is mm/dd/yyyy
Each country/language has a short date format default pre-defined.
So your global admin would need to select the country/language that is appropriate for your organization (and, of course, have previous approval/communication)
I don't have much hands-on with the Classic Designer, however, it looks like the string format expression and "apply formatting to input mode"=Yes look to be appropriate.
Looks like you should open a support case
Looks like you should open a support case
Userlevel 6
+22
There is a known bug around the string format on input mode so it does not work. Alswo if it was working there would be no need to use a function. just doing mm/dd/yyy would be enough.
I think setting the format with regional settings is a better idea.
I think setting the format with regional settings is a better idea.
+3
i just tried with just writing the format string and it didnt do the magic. i will have to wait until the admin gives me rights to change it through the regional settings. thanks @SimonMuntz
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.