I checked, the date column is configured as date/time column, and I’m using the special “Now” value.
I removed the ‘.25’ to void any issue related to comma vs. dot usage.
ah, yes… there was a recent change to the behaviour when you subtract one date from another that means that formula no longer works.
Try this instead: Floor(Round(Now-Date)/365.25)
4 Likes
Yes, thanks, this one works. But it gives the age.
What I need is the time (in days) between now and a birthday, without requiring a person to enter their last birthday.
So that in a calendar view, I can show upcoming birthdays in the right order.
Maybe this post by Robert will help here!
Take a look at this
2 Likes
What if I want to add months to that date and not days? Like “Add 3 months to the date of payment” to have an expiring date.
See below:
1 Like