Table Validation Rule for Date

[deb]

I want to set up a validation rule in my table.
It needs to verify that the date field has a 1 as the date.

The format is 12/1/2007. I need all entries to be MM/1/YYYY

Thanks bunches,

 

[Stefan Hoffmann]

hi Deb,

The format is 12/1/2007. I need all entries to be MM/1/YYYY

Try Day([Fieldname]) = 1.

mfG
--> stefan <--