Date validation question

[hardrock]

I've got a date validation in a property box, basically i want to accept a date entry that is equal to or before todays date. This is what i have so far

Validation rule: <=Date()
Validation text: Cant be higher than todays date

Looks ok right? but if enter todays date, i still get the message "Cant be higher than todays date" Whats wrong with the rule?

And yes, my system date is correct!

Cheers!

 

[hardrock]

re

thanks mate!

 

[Dreamweaver]

I re-read your post the edits what ya need I think

Mick

 

[hardrock]

re

what do you mean m8?

i tired <date() it wont accept todays date, so something is missing?

 

[Dreamweaver]

I'll give it a go just so I'm not seeing things Back in min

 

[Dreamweaver]

Try This

Not >Date()

It wont allow anything from tomorrow onwards but allows today and older dates

 

[Dreamweaver]

Just tried <=Date() and it works on my system???

 

[Dreamweaver]

Have you got rules in both your form and table and are they the same???

 

[hardrock]

re:

something is definately strange in my ac2003! i tried both variants and still no joy.It wont accept todays date! I went into the table, BTW this is linked to a repository in Ac97 format in another database and inserted the validation rules as suggested above into them. saved everything and tried again!
Still the same!

 

[Dreamweaver]

So you have an Acess 97 Backend with 2003 front are you using a form or is the validation rule in the table,

Whats for format of the table field and is it general date not sure how thats gonna help but you could try formating the Date if on a form.

could be a 2003-97 thing? I don't use 97 anymore all my backend are in 2000 and fronts 2002/3 as I use access and VB

Mick

 

[Dreamweaver]

as a thought if your using a form you could use code in the before update that does the validation??

 

[hardrock]

re:

fixed it by simply redoing the validation mask in the property. Can you believe