This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
What I try to do is to populate the Calendar with birthdates from Contacts. I found a way to display 1 year from now, but not further into the future.
To do this, I made a virtual column with this formula:
date(month([birth date]) & โ/โ & day([birth date]) & โ/โ & if(month([Birth date])<month(today()),year(today())+1,year(today())))
Now I want to replace the last part :
if(month([Birth date])<month(today()),year(today())+1,year(today()))
with
Year(CalendarYear())
or something like that if its possible?
I believe date/time expressions have higher requirements to consider about exceptions and special cases to construct and need better testing. The above expression, for example, I believe will not work for those with birthdates as 29th February as the date of 29th Feb comes only once 4 years in a leap year.
So in general, l believe what you are looking at should be possible and one can construct an expression but will need good testing and need to take care of exceptions like 29th Feb.
I think that will not be an issue since 29th does only exist in a leap year and thus the birthday will only be populated into the calendar during leap years which is expected.
The question though, was if a property can be retreived from the Calendar that indicates the month/year shown.
LinkedIn
Twitter
