Anyone have experience using the Calculated Fields Bundle (https://www.npmjs.com/package/@directus-labs/calculated-fields-bundle) I am trying to use it to calculate the age of an item based on a field. Any help would be appreciated.
I tried this but it doesn’t seem to work:
DATEDIF(Date of Birth, NOW(), “Y”)
Hi @tonypiazza,
don’t know if this is still relevant or if you figured it out in the meantime. But better late then never:
I tried the formula you suggested in your own answer and it seems to work without an problem on my end.
Formula setup:
Working calculation:
A couple of ideas what might be different between our setups:
- For this example I used the “Date” field type which only stores “YYYY-MM-DD”. I’ve also tried it with
DateTime, which also works. If you are still interested maybe you could share your field setup?