Date/Time Validation Rules

[DrSporkeh]

Hai everyone, i need some help :o

basically im trying to set some validation rules for an 'employees' table.

firstly i've set it to you have to be 16 to work here under 'Date Of Birth'

<DateAdd("yyyy",-16,Date())

simple and good enough for me.

but, i would like a validation rule for for 'Date Employed' as currently you can be employed before your born o.Ó which.. doesn't make much... sence....

if you could help me much love will be given :D

[ChipR]

You can certainly do
>[txtDateOfBirth]
referrring to the text box that holds the date of birth. I think no date will be valid until txtDateOfBirth is entered, so you might want to force them to fill out the date of birth first by locking or disabling the field until after the date of birth is updated.

[DrSporkeh]

thanks but it didnt work o.Ó

although i did find a way

with the field selected going to the properties sheet and putting
[Date Of Birth] < [Date Employed]
that did it fine

thanks anyway

Much Love

<3 Sporkeh <3