Date Validation in Calendar

[aparnawangu]

Hi Team,
I have a query regarding Date validation in access.
I have a field called Enquiry date and the criteria is that the user should be able to select dates past 15 days only beyond that the system should not allow dates to be selected.
Further the user should not be able to select the date later than current date.
Pls suggest me the solution.

Thanks Aparna

 

[arnelgp]

on the controls propety:

Validation Rule: < Date()-15
Validation Text: Date should be less than 15 days from now!