The FormatShortDate function is a built-in function that builds a Text output of the specified Date value in the format YYYY-MM-DD, separating all date components with date_separator.

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

Input parameters

value: Date Type

date_separator: Text Type

Output parameters

Text Type




FormatShortDate( #2001-09-14#, "/" )


FormatShortDate( #2001-09-14#, " ^ " )


FormatShortDate( #2001-09-14#, "" )


See Also

Available Formatting Functions | Available Built-in Functions