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

Examples

Usage

Result

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

"2001/09/14"

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

"2001^09^14"

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

"20010914"

See Also

Available Formatting Functions | Available Built-in Functions