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

Back All Commands All Math & Logic Commands

AGE

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

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
A = Auto

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 The Current Date & Time String The date to compare with.
5 date_2_format date 1 format Integer The format of date 2
6 timezone Europe/London String The Time Zone to use for the comparison
Auto Format Example
2 years 184 days 17 hours 24 minutes
Example 1 Age. Example
54
Example 2 Between Dates in Months Example
19
to add a Comment.