I’m trying to calculate the amount of years a person has been the member of an association. This is required on a monthly basis (as it is being published in a monthly magazine). I have the entry date of a member and I would have to combine it somehow with the current date. But as you probably know, calculated columns cannot use the [Today] parameter. How could I possibly solve this?
Thanks a lot 🙂
(Visited 48 times, 1 visits today)
dj_zone_2 Answered question April 12, 2018
To use Today’s date in a calculated column, you can first create a date column and assign today’s value as default for it. Then use this first column in your calculated column field.
(Visited 1 times, 1 visits today)
Mark Jones Posted new comment April 10, 2018
unfortunately, this field then has the value of the date, where the element has been created, but I need this one regularly updated based on the date where the anniversary record is created