Date picker - must not be more that 6 yrs from today

I am attempting to provide a training module for work relating to Motor Claims.

The end user must select an incident date. There is a check in place to ensure it is not in the future but I cannot seem to find a way to restrict the user from entering a date less than 6 years from today's date. E.g. if incident date selected from the calender is more than 6 years ago from today then msgbox (cannot claim if occurred more than 6 years ago) and return to calendar to select a date.

Currently I have the following which works to ensure date is not on the future.

Please Login or Register  to view this content.

Dateadd does note seem to work with the calendar. Any ideas?

Thank you, worked a treat!

You're welcome, and thanks for the rep!

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."