Problems with static dd/mm and rolling year
Hi!
Im currently trying to create a database for work to flag up documents which are due for review each year. The IF statements are all working for this system but the one thing which is creating problems is that I cant seem to find the correct formula to show the review date (Which is an annual static dd/mm each year) but have the year part automatically rolling over to the current year.
This is probably a really silly question but I can't seem to find an answer anywhere on the net!
Thanks in advance! x
|