format date

[mdagostino]

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!

[rohansm83 · Accepted solution]

You can use this formula,

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

Refer this article for different date formats.

[mdagostino]

Thank you Rohan!

[sonam29]

Hi ,

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

please suggest.

BR/Sonam