Hello,
I need to input two validation rules for date fields. Here are the specifics:
1. Field1 is called [Purchase_Date]. Any data must be in or after 1959, so the validation rule I entered is >#12/31/1958#.
2. Field2 is called [Labor_Date]. Any data must be not only in or after 1959, but must also be on or after [Purchase_Date] (labor cannot be performed until after payment is received). I initially thought I may need two validation rules, both >#12/31/1958# and [Labor_Date]>=[Purchase_Date].
Is this even close to right? When I typed these codes concurrently into the validation rule box for Field2, I came up with a syntax error. I then tried just the latter rule by itself, knowing that the Purchase_Date used as a comparison in Field2 is already after 12/31/1958. Still came up with a syntax error. Help!
Thank you in advance.