Date and Time format

[Athilingam_S]

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

[Jean-Balteryx · Accepted solution]

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 · Accepted solution]

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

[Athilingam_S]

Hi Jean Balteryx

Thank You 

[Athilingam_S]

Yes its really help Thank you