Format a date or time value

To show the date or time value in a specific format, use the Format function in combination with format codes.

Examples:

• Show a date in the format "Monday, August 3":

  =Format(Injection_AcquiredDate,"dddd, MMM d")

• Add the GMT time offset information to a date, in the format "05/05/2015 3:50:00 AM GMT+2:00":

  =Injection_AcquiredDate & " GMT" & Format(Injection_AcquiredDate,"zzz")

• Show the date in ISO-8601 standard format, as in the OpenLab CDS application:

  =Format(Injection_AcquiredDate,"yyyy-MM-dd HH:mm:sszzz")

  This format is recommended in a compliant environment. It shows the date and time unambiguously for all time zones in the world.

See Also

• Format Codes