Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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