Change Date Format

[jason_clough14]

I need to get my date from mm.dd.yyyy to mm/dd/yyyy, see below example.

Incoming - 11.26.2019

Target - 11/26/2019

Thanks

[JosephSerpis · Accepted solution]

Hi @jason_clough14 you could use a replace function to change . to / that would work.

[echuong1]

If you don't mind the values being in strings, you can use regex replace. See attached for an example. 

[Inactive User]

Hi folks,

Just wanted to know if we change the date format to "DD-Name of the Month-YY? For example, today's date, "20-May-20".

Similarly to "DD-Name of the Month-YYYY"?  For example, today's date, "20-May-2020"

Regards,

Shivam.