Feature Rich
Rapid Application Development
Helping you or your customers
Manage their Business

Back All Commands All Format Commands

FORMAT_DATE

Format a date using the php date() function

Valid Format characters include:
  • d - The day of the month (from 01 to 31) - 04
  • D - A textual representation of a day (three letters) - Wed
  • j - The day of the month without leading zeros (1 to 31) - 4
  • l (lowercase 'L') - A full textual representation of a day - Wednesday
  • N - The ISO-8601 numeric representation of a day (1 for Monday, 7 for Sunday) - 3
  • S - The English ordinal suffix for the day of the month (2 characters st, nd, rd or th. Works well with j) - th
  • w - A numeric representation of the day (0 for Sunday, 6 for Saturday) - 3
  • z - The day of the year (from 0 through 365) - 215
  • W - The ISO-8601 week number of year (weeks starting on Monday) - 31
  • F - A full textual representation of a month (January through December) - August
  • m - A numeric representation of a month (from 01 to 12) - 08
  • M - A short textual representation of a month (three letters) - Aug
  • n - A numeric representation of a month, without leading zeros (1 to 12) - 8
  • t - The number of days in the given month - 31
  • L - Whether it's a leap year (1 if it is a leap year, 0 otherwise) - 0
  • o - The ISO-8601 year number - 2021
  • Y - A four digit representation of a year - 2021
  • y - A two digit representation of a year - 21
  • a - Lowercase am or pm - pm
  • A - Uppercase AM or PM - PM
  • B - Swatch Internet time (000 to 999) - 668
  • g - 12-hour format of an hour (1 to 12) - 3
  • G - 24-hour format of an hour (0 to 23) - 15
  • h - 12-hour format of an hour (01 to 12) - 03
  • H - 24-hour format of an hour (00 to 23) - 15
  • i - Minutes with leading zeros (00 to 59) - 03
  • s - Seconds, with leading zeros (00 to 59) - 02
  • u - Microseconds - 000000
  • e - The timezone identifier (Examples: UTC, GMT, Atlantic/Azores) - UTC
  • I (capital i) - Whether the date is in daylights savings time (1 if Daylight Savings Time, 0 otherwise) - 0
  • O - Difference to Greenwich time (GMT) in hours (Example: +0100) - +0000
  • P - Difference to Greenwich time (GMT) in hours:minutes - +00:00
  • T - Timezone abbreviations (Examples: EST, MDT) - UTC
  • Z - Timezone offset in seconds. The offset for timezones west of UTC is negative (-43200 to 50400) - 0
  • c - The ISO-8601 date (e.g. 2013-05-05T16:34:42+00:00) - 2021-08-04T15:03:02+00:00
  • r - The RFC 2822 formatted date (e.g. Fri, 12 Apr 2013 12:01:05 +0200) - Wed, 04 Aug 2021 15:03:02 +0000
  • U - The seconds since the Unix Epoch (January 1 1970 00:00:00 GMT) - 1628089382

See php.net/manual/en/function.date.php for more details.

Number Name Default Type Description
1 format d/m/Y H:i:s String Format. For a full date and time use, jS F Y H:i:s
2 date Current date/time as a unix time stamp String The date to format.
3 date_format -1 Integer

The format of the submitted date, as defined below.

  1. Unix timestamp.
    This is the default format for an Object or Relationship Amended Date
  2. YYYY-MM-DD HH:MM:SS
  3. DD/MM/YYYY HH:MM:SS
    This is the default format of a date held on an object.
  4. MM/DD/YYYY HH:MM:SS
  5. YYYYMMDD

Hours, minutes and seconds are optional (00:00:00 will be used if not submitted) and seconds can be decimal.

4 adjustment String

The amount (represented as a string) to adjust the date by.

e.g. 1 second, 2 minutes, 3 hours, 4 days, 5 months or 6 years

Prefixing a - will cause the interval to be subtracted from the date.

Some other possible adjustments:-
first day of this month
last day of this month

- language en String The language to translate the date to.
The Language needs to be setup in the Organisation/Site Content/Language list and the Day and Month translations need to be included.
In French Example
mercredi 4 août 2021
Relative Dates Example
Today: 04/08/2021
This Working Week: 02/08/2021 - 06/08/2021
This Month: 01/08/2021 - 31/08/2021
Today Example
04/08/2021 15:03:02
4th Aug 2021
to add a Comment.