ULTIMATE DATABASE
HIGH QUALITY BESPOKE SOFTWARE DEVELOPMENT TOOL
Feature Rich
Rapid Application Development
Helping you or your customers
Manage their Business

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 GMT String The Time Zone to use for the comparison
Auto Format Example
5 years 152 days 18 hours 9 minutes
Example 1 Age. Example
58
Example 2 Between Dates in Months Example
19
Same Day Example Example
0
to add a Comment.
DATE/TIME Commands
CALENDAR
FORMAT_DATE
STEALTH_MODE
TIMEZONE
TIMEZONE_OFFSET