Skip to main content

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!

You can use this formula,

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

185497_pastedImage_0.png

Refer this article for different date formats.


Thank you Rohan!


Hi ,

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

please suggest.

BR/Sonam


Reply