A
G
E

<-- Back to Tags

{AGE(format, date, date_format)}

This function will either determine the age of a specified date or the difference between two dates.

Parameters
Number Name Default Type Description
1 format S String

The format of the returned age.

S = Seconds
M = Minutes
H = Hours
D = Days
W = Weeks
O = Months
Y = Years

2 date String The Date to compare
3 date format -1 Numeric

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

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

4 date_2 Now String The date to compare with.
5 date_2_format Parameter 3 Integer The format of date 2
Log in to add a Comment.