Format

Format function

Converts a value to text in a specific number, date time, or string format based on the current UI culture.

Syntax

Format(scalar Value, scalar FormatString)

Arguments

Argument	Description
scalar Value	Value to be converted
scalar FormatString	Format for output

Examples

Format(Today(),"d MMMM yyyy")

Formats current date as "9 august 1999".

Formats current date as "08-09-99".

Formats the number using the thousands separator.

Formats a number as currency.

Formats the number, padded to produce 5-digit.

Formats a string left-justified within a 10-column field.

Formats a string right-justified within a 10-column field.