DateConvert

The DateConvert function receives two inputs: a date/time string, and a the desired output date\time format. The function converts the input string to the requested format and returns the new string in the specified format.

If the provided input is not a valid string, or if the converting process fails (for example, the text is not in a valid date format), the function returns NULL.

Syntax

DateConvert(date/time text string, requested output date/time format text string)

Example

DateConvert("09/03/2023","dd/MM/yyyy")-> returns '03/09/2023'

DateConvert("09/03/2023","dddd, dd MMMM yyyy")-> returns 'Sunday, 03 September 2023'

DateConvert("09/03/2023 03:45:00 PM","yyyy-MM-ddTHH:mm:ss")-> returns '2023-09-03T15:45:00'

DateConvert("16:53:00","hh:mm tt")-> returns '04:53 PM'