Using date field to know hoe long a user is with me?

Hey,

I’m getting from our platform a contact field that give me the date they created their account. I’d like to translate that to the number of years they’re with us.

For instance, a user that made his account 6 months ago the number would be 0.5.

Thanks

Hi @vitormfs , thanks for posting on this community!

From what I see here: https://help.brevo.com/hc/en-us/articles/209558545-Build-and-use-formulas
I understand that DATE_DIFF or something similar does not exist in Brevo.

Could there be a way for you to calculate the difference between two dates before you upload the contacts to Brevo?