Hi i am creating a database im ok, just havent used it for years and years. I need a defult value which will add todays date. And a validation Rule that will prevent date entries prior to 1/1/2002
Can anyone please help me!! Thanks Jay
AND MY INPUT MASK IS SHORT DATE
Use [Now] as a default value
i also need the validation rule plz can some1 help?
i also need the validation rule plz can some1 help?
i also need the validation rule plz can some1 help?
Format mm/dd/yy
Default Value Date$()
Validation Rule =[Text8]>#12/31/01#
The validation rule is used under properties of the TEXT8.text
[IMG]http://www.kegtapper.net/images/Validation.jpg[/IMG]
And that will produce this error
[IMG]http://www.kegtapper.net/images/ErrorMsg.jpg[/IMG]
set default value as ="date"() if his doesnt work
also if he isnt american he wont want the date format u have specified in post above
his text "Hi i am creating a database im ok, just havent used it for years and years. I need a defult value which will add todays date. And a validation Rule that will prevent date entries prior to 1/1/2002"
Wanted American format
his text "Hi i am creating a database im ok, just havent used it for years and years. I need a defult value which will add todays date. And a validation Rule that will prevent date entries prior to 1/1/2002"
Wanted American format
1/1/2002 can also be uk :P lmao
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.