Validation Rule and Date() probelm 1

[djj55]

Hello, In Access 2002 I have an Access database that uses a validation for a date. The date is linked to an SQL data table.

The validation works on some workstations and not others. throwing an error that states invalid function, which is not the Validation Text, even if the date is valid.

If I log on as an administrator (network) and try to edit the Validation Rule it gives an error on Date(), however, it will let me use Now().

Now the biggest problem is that it works on my system so I can not debug without accessing someone else's computer.

Now() is not a good fix as no time is being entered.

If there is a way to use Now() to compare to a date only that might work.

Does anyone have suggestions?
djj

 

[PHV]

INT(Now())

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[djj55]

Have a star!

I would not have thought to use INT with a date.
djj