Hello,
I have an input form in Access 2010 and I would like to put data validation on a few of the date fields (at form level). This form use to be in Excel.
I am in Design view of the form, in the Properties of the field, Validation Rule. I have tried several attempts but it is not working, as far as I can get is >=Date() which is today and/or greater than today or just =Date() today. Nothing else works even if I try to add 30 Days to today.
What I need is the following:
The field I want the validation on is called [LTARRecDate] so I need to write something that looks at the Access field [LTStartDate] and whatever that date is negative -15 from that and then Today's date and plus 30 days.
The Excel data validation looks like the below:
Allow: Date
Data: Between
Start Date: References the Cell Number where the date lives =B2-15
End Date: =Today()+30
I need this in Access format for the same type of data validation. Is this possible?
Any help is so appreciated. Thank you.
Lilly
:banghead:
I have an input form in Access 2010 and I would like to put data validation on a few of the date fields (at form level). This form use to be in Excel.
I am in Design view of the form, in the Properties of the field, Validation Rule. I have tried several attempts but it is not working, as far as I can get is >=Date() which is today and/or greater than today or just =Date() today. Nothing else works even if I try to add 30 Days to today.
What I need is the following:
The field I want the validation on is called [LTARRecDate] so I need to write something that looks at the Access field [LTStartDate] and whatever that date is negative -15 from that and then Today's date and plus 30 days.
The Excel data validation looks like the below:
Allow: Date
Data: Between
Start Date: References the Cell Number where the date lives =B2-15
End Date: =Today()+30
I need this in Access format for the same type of data validation. Is this possible?
Any help is so appreciated. Thank you.
Lilly
:banghead: