How to use Calculate Age in Property Transformer
The Calculate Age action lets you automatically calculate a contact's age from a date property and assign them to an age range bucket. This is useful for segmenting contacts by age group directly in your HubSpot workflows.
This action works on all object types including Contacts, Companies, Deals, and Custom Objects.
Supported property types:
- Date picker
- Single-line text
2. Under "Integrated Apps", find "Brave Tools"
3. Select "Calculate Age"
4. Configure the input fields (see below)
5. Map the output values to the properties you want to update
Select a HubSpot date picker property (e.g. "Date of birth"). Use this when the property is a standard date field in HubSpot.
Date of birth (text)
Select a single-line text property that contains a date as text (e.g. "611202"). Use this when the date is stored as a text string instead of a date picker.
Date format (for text field)
Choose the format that matches your text date value. Available formats:
Auto-detect (for standard HubSpot dates)
Supported property types:
- Date picker
- Single-line text
How to set it up
1. In your HubSpot workflow, add a new action2. Under "Integrated Apps", find "Brave Tools"
3. Select "Calculate Age"
4. Configure the input fields (see below)
5. Map the output values to the properties you want to update
Input fields
Date of birthSelect a HubSpot date picker property (e.g. "Date of birth"). Use this when the property is a standard date field in HubSpot.
Date of birth (text)
Select a single-line text property that contains a date as text (e.g. "611202"). Use this when the date is stored as a text string instead of a date picker.
Date format (for text field)
Choose the format that matches your text date value. Available formats:
Auto-detect (for standard HubSpot dates)
- yyMMdd (e.g. 611202)
- yyyyMMdd (e.g. 19611202)
- ddMMyy (e.g. 021261)
- ddMMyyyy (e.g. 02121961)
- MMddyyyy (e.g. 12021961)
- MMddyy (e.g. 120261)
This field is only needed when using the text property field.
Age ranges
Define custom age range buckets as a comma-separated list (e.g. "0-17,18-24,25-34,35-44,45-54,55-64,65-100"). Leave this empty to use the default ranges.
Output fields
Age - The calculated age as a whole number.
Age range - The matching age range label (e.g. "25-34").
Example
A contact has a text property "birthday_source" with the value "611202".
Configuration: Date of birth (text) = birthday_source, Date format = yyMMdd
Input: "611202"
Output: Age = 64, Age range = "55-64"
Good to know
- The action supports both standard HubSpot date properties and text-based dates.
- Dates before 1970 are fully supported.
- If the date field is empty or cannot be parsed, the output fields will be left empty and the workflow will continue.
- Property Transformer is available on paid plans. Trial users do not have access to this feature.