topic Re: Need to change date format in Workato Pros Discussion Board

Need to change date format

MurugarajSa — Fri, 27 Oct 2023 18:19:08 GMT

Hi,

How do I change the date format from 02-Oct-23 to 02-10-2023.

Is there a way to achieve this by workato formula?

gary1 — Fri, 27 Oct 2023 18:55:08 GMT

Ruby interprets "23" very literally, so it thinks the date is October 2 (day), 23 (year)

If all of your years are over 2000, you can do this:

"02-Oct-23".to_date + 2000.years ## outputs 2023-10-23

From there, you can do this:

[date].strftime("%d-%m-%Y") ## outputs "02-10-2023"

This site is a great reference for using strftime to reformat dates: https://strftime.org/

MurugarajSa — Sat, 28 Oct 2023 05:17:26 GMT

It works perfectly. Thank you so much!