Announcement

Collapse
No announcement yet.

Calculating Ages etc

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    Calculating Ages etc

    Hi, can please anybody help me with the formula to calculate ages for example? Its the datediff expression, but you have not only to take care of not years, but also months and days. How can I combine this? Thanks a lot, regards Michael
    Tags: None
  • #2
    Hi,
    just using formula without a workflow isn't a good idea, because formula can update values only, when you save a record.
    Birthday notifications in EspoCRM
    https://www.espocrm.com/blog/birthday-notifications-in-espocrm/
    With Workflow feature it's possible to make the system to send notifications about birthdays of contacts or other entities like users, leads. You need to have a date field that represents date of birth in your entity (e.g. entity Contact, field dateOfBirth). You can create it in Entity Manager.



    fullYears=datetime\diff(datetime\today(), birthday, 'years');
    this formula works ok

    Birthday
    22 May, 2016
    FullYears
    1

    Birthday
    05 May, 2016
    FullYears
    2

    Comment

    • #3
      Thank you, you‘re right. I didn‘t consider that age is only actual at the point when a contact is saved when using a formula. So I‘ll try to solve the problem with workflow. Regards Michael

      Comment

      Previous template Next
      Working...
      X