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?

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.