How do we calculate age from date of birth field?

[sujithraalink]

I have 2 fields date of birth(date field) and age(varchar). can we calculate age from date of birth field . can we do it from front end. Please help me.

[Maximus]

Hi,
you can try to achieve this w/o front-end by utilizing a scheduled workflow with a report that uses a logic described here https://www.espocrm.com/blog/report-...have-birthday/.

[esforim]

Don't have Workflows package or Reporting package.

Any way to convert a date into a number then convert it back into a date format? Similar way to how Excel does it.

Other relevant thread: https://forum.espocrm.com/forum/gene...of-birth-field

[Maximus]

The Workflow and Report features are available in the Advanced Pack https://www.espocrm.com/extensions/advanced-pack/.
The way provided above with utilizing Workflow and Formula allows calculating the age dynamically.