Date Time change to dd-Mmm-yyyy

[Amy123]

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

[JosephSerpis · Accepted solution]

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.