2003 Version - date field cannot contain today's date

[Lori Hughes]

It's been a while since I worked with this version.
I have a date field in a table that cannot contain today's date.


Silly me - I waded in with Excel's function 'today'.
OK - stop laughing.

Now I've gone around in circles and still haven't discovered the answer.

Please kind people - help!
Lori

[ssanfu]

I've done the same

Use Date() for just the date
Use Now() for the date and time.

The parenthesis might go away - don't be concerned...

[Lori Hughes]

Steve!

Thank you for your help, and understanding!

Now - I'm going to ask one more thing.

Do I just put Date() in the Validation Rule field in Design Mode for the Table?
I'm asking now, because I won't have access to this information until work on Monday.

Thank you again!
Lori

[ssanfu]

No problem...
Sorry for taking so long to respond... busy weekend...

If the field cannot have today's date, try

<> Date()

You can use any of the operators: <, >, =, <>, <=, >=