FORMAT_DATETIME
Description
Formats a Date or Datetime as a string.
Syntax
FORMAT_DATETIME(date/datetime, format_string_optional, timezone_optional) -> String
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| date/datetime | Date/Datetime | Yes | The Date or Datetime to format. |
| format_string_optional | String | No | The format pattern. Defaults to a standard format if not provided. |
| timezone_optional | String | No | Time zone identifier (e.g., 'CST'). Defaults to the user's local time zone. |
Examples
FORMAT_DATETIME(CreatedDate)
-- Returns CreatedDate as a formatted string (e.g., "3/9/2022, 3:06 PM") in user's local time zone.FORMAT_DATETIME(NOW(), "yyyy-MM-dd HH:mm:ss", "PST")
-- Returns the current Datetime as a string formatted as "yyyy-MM-dd HH:mm:ss" in PST.Tips
Format patterns: yyyy for year, MM for month, dd for day, HH for 24-hour, hh for 12-hour, mm for minute, ss for second.