Skip to main content
Nintex Community Menu Bar

format date

  • June 1, 2016
  • 3 replies
  • 10 views

Forum|alt.badge.img+7

All,

I am updating the name field of a document with information from other columns. I am running into the following issue: I have a date field that is formatted as DD-MM-YYYY. In the name field I need this field to be YYYY-MM-DD. how can I flip it around. If I create a variable will that work? or should I use the Build a string?

Thank you in advanced for your help!

3 replies

Forum|alt.badge.img+3
  • June 1, 2016

You can use this formula,

fn-FormatDate({ItemProperty:DateColumn},"yyyy-MM-dd")

185497_pastedImage_0.png

Refer this article for different date formats.


Forum|alt.badge.img+7
  • Author
  • June 1, 2016

Thank you Rohan!


Forum|alt.badge.img
  • April 26, 2018

Hi ,

Where to use this formula , I tried in set variable option but its not working..

please suggest.

BR/Sonam