Alteryx Designer Desktop Discussions

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

Date and Time format

Athilingam_S
7 - Meteor

Experts

Please guide me how can i change the below data exact date and time format

 

16-AUG-2020 03:05:48
27-JUL-2021 19:27:23
29-JUL-2021 17:23:51
29-JUN-2018 18:43:29

 

4 REPLIES 4
Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @Athilingam_S ,

 

You can do it using the following expression in a formula tool :

 

DateTimeParse([Date], "%d-%b-%Y %H:%M:%S")

 

The DateTimeParse function transforms a string in the specified format into a date field.

 

I attached the workflow.

ArtApa
Alteryx
Alteryx

Hi @Athilingam_S - You can use DateTime, which is a very intuitive tool:

 

ArtApa_0-1628034427360.png

 

Athilingam_S
7 - Meteor

Hi Jean Balteryx

 

Thank You 

Athilingam_S
7 - Meteor

Yes its really help Thank you 

Labels
Top Solution Authors