The FormatFullDateTime function is a built-in function that builds a Text output of the specified DateTime value in the format DD-MM-YYYY hh:mm:ss with a full textual representation of the month, separating all date components with date_separator and all time components with time_separator. The date and time components are separated by a blank space.

Changing the environment date format, does not change the way the FormatFullDateTime function formats the dates.

Input parameters

value: DateTime Type

date_separator: Text Type

time_separator: Text Type

Output parameters

Text Type




FormatFullDateTime( #1982-05-21 22:20:30#, " of ", ":" )

"21 of May of 1982 22:20:30"

See Also

Available Formatting Functions | Available Built-in Functions