The Format Function

The Format function is used to format strings, numbers, and dates. Table 8-3 gives a few examples.

Table 8-3. Format Function Examples

Expression

Return value

Format(Date, "Long Date")

Thursday, April 30, 1998

Format(Time, "Long Time")

5:03:47 PM

Format(Date, "mm/dd/yy hh:mm:ss AMPM")

04/30/98 12:00:00 AM

Format(1234.5, "$##,##0.00")

$1,234.50

Format("HELLO", "<")

"hello"

Tea 87Fly®

0 0

Post a comment