date/time validation rule

[Marek Marek via AccessMonster.com]

people i cant find any usefull documentation in microsoft access help for
creating date/time validation rules for controls.

my task is to create validation rule:
(>=DateValue("01/01/1990") And <=DateValue("01/01/2000")) And
(>=TimeValue("00:00") And <=TimeValue("00:00"))



how to do this validation rule workable

 

[Allen Browne]

Try:
Between #1/1/1900# And #1/1/2000#

The TimeValue() part does not look relevant, unless you are trying to insist
there is no time component to the entry.

Literal dates should be enclosed in #, and formatted as mm/dd/yyyy. If you
live in a country with a different date format, see:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

in message
news:[email protected]...