Extended Date format

I want write date format in extended format which shows full month and year and date

1 Like

Yes, with the help of Date_parse you can do it.

Apply formula : DATETIME_PARSE("(date field type), "D MMM YYYY HH:mm ")

Example: DATETIME_PARSE("26 Nov 2019 23:00", "D MMM YYYY HH:mm ")

Result: 27th November, 2019 04:30 AM

1 Like