Convert a variable to date format

[Jose_Miguel_Almonte]

I want to convert a variable in date format using “/” or “-” How would this procedure be done?

For example:

• From 03012023 to 01/03/2023
• Or from 03012023 to 03-01-2023

Thank you!!

[Mabwa_Neek]

Hello @Jose_Miguel_Almonte, You can use the moment.js library for this. Please refer to this post for a comprehensive guide:

And please let me know if this works for you.

Dates and Time

Dates and Time If you need to parse the format of the date, validate, manipulate or translate the date variable to another language you can use moment.js library. Choose the required method from the library and enter it in “Calculate a value” mode: [image] Format Dates moment().format(‘MMMM Do YYYY, h:mm:ss a’); // November 3rd 2022, 2:50:04 pm moment().format(‘dddd’); // Thursday moment().format(“MMM Do YY”); // Nov 3rd 22 moment().format(‘YYYY [escaped] YYYY’); // 2022 escaped 2022 mo…

[Jose_Miguel_Almonte]

Thanks, problem solved!

[Muhammad_Hayyan]

Hi @Jose_Miguel_Almonte

It will be helpful if you can share the solution. Thanks in advance.

Kind Regards,
M. Hayyan Khan