Date and Time format

Question

Experts

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

16-AUG-2020 03:05:4827-JUL-2021 19:27:2329-JUL-2021 17:23:5129-JUN-2018 18:43:29

Jean-Balteryx · Accepted Answer

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 Answer

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