Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Change Date Format

Highlighted
7 - Meteor

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

 

Replace_261119.PNG

Highlighted
Alteryx
Alteryx

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

Highlighted
5 - Atom

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.

 

Labels