Announcement

Collapse
No announcement yet.

How do we calculate age from date of birth field?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How do we calculate age from date of birth field?

    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.

  • #2
    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/.

    Comment


    • #3
      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

      Comment


      • #4
        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.

        Comment

        Working...
        X