Calculates age based on a date field and sets it to another field.
To set the calculated age in the field, create the field in the application and select that field in “Field to set age”.
If you want to convert the calculated age to a field etc. by processing the format like ‘full 30’ instead of just a number, do as follows.
= "Full" & $ 1 & "old"
The age is calculated by the date at which the action was performed and the age at the end of the birth date.
The date on which the action was performed is based on the regional settings of the user’s browser. If you are using a Japanese browser, it will be in Japan time.
Set the Date or Date Time Field and Age Set Field.
Select a date or time field that contains a date that represents a birthday.
If you select a datetime field, the time is not considered in the calculation.
Specify the field to set the calculation result. It is optional.
The available field types are:
If omitted, the age is not set in the field. It is possible to reference from other actions even if omitted.
The Current Date is based on the time zone setting of the logged-in user. The time zone is set to “(UTC+09: 00) In the case of Osaka, Sapporo and Tokyo”, it will be Japan time.