We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Date Time change to dd-Mmm-yyyy

Amy123
8 - Asteroid

Hi Team,

 

How to change the date time in "dd-Mmm-yyyy" right now its in below format.

RECEIPT_DATE
2021-09-30 19:52:07

Regards

1 REPLY 1
JosephSerpis
16 - Nebula
16 - Nebula

Hi @Amy123 I mocked up a workflow using the formula Datetimeformat and the specifiers from this page you can change your date into a format you desire. However if you perfrom this transformation your Date field will need to be a string field as the current format of your data is only recognised Date field type in Alteryx. You can also use the datetime tool to try this transformation as well.

 

Datetimeformat_14102021.JPG

Labels