Skip to main content
Nintex Community Menu Bar

Format Date/Time Function Does not give correct result

  • Jan 16, 2018 9:36 AM UTC
  • 4 replies
  • 47 views
  • Translate All

I used the format date and time function(format(date, yyyymmdd) to convert 20*personal details removed* to 20180101.

But what I get is 20180001. The month value is incorrect. I have tried various date values and I get same result.

4 replies

VictoriaD
Forum|alt.badge.img+9
  • Novice
  • Jan 16, 2018 2:49 PM UTC

Try yyyyMMdd

Translate

  • Jan 16, 2018 3:27 PM UTC

Have you tried changing the style of the control instead?  Select Styles for the control.  Select Format , then select one from Date and Time or select Custom and specify the date format.

Translate

VictoriaD
Forum|alt.badge.img+9
  • Novice
  • Jan 16, 2018 3:29 PM UTC

I had previously replied to this thread, not sure why it's missing... but I had suggested trying yyyyMMdd.

Translate

Forum|alt.badge.img+9
  • Jan 19, 2018 7:05 AM UTC