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