asked on

Date & time validation

hi!
I am not really good in access at all, however i have a job to use an access database with delphi via ADO.

i was wondering, what exactly do i need in the validation text boks to check that we have typed in a date. and another box for time...

time() is no good... since it prints both time & date...

Jim Dettman (EE MVE)

It's not clear if your using Delphi just to look at the data, or are using Access for the programming. If your using Access, you'd use the IsDate() function to return a logical to check for a valid date.

Jim.

muzori

put in text box like this
=date()

marcoszorrilla

If you use Delphi via ADO I suppose, or BDE, in both cases you must DoubleClic the TAdoTable, or Ttable and then right button of the mouse - Add all fields.

Now, if you has the little box with all the fields and the form tha you use to enter the data, select a Date or Time field and in the set the EditMask property for exaple !99/99/0000;1;_ for Date, or !90:00:00;1;_ for time.

Then you select the fiedl and drag it and drop over the form. thats all.

Best Regards.
Marcos.

joepezt

ASKER

marocs: how do i put this in the validation rule in my access database?

date (!99/99/0000;1;_) ?

ASKER CERTIFIED SOLUTION

marcoszorrilla

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

joepezt

ASKER

hehe, ok, I have been blind ;)
thanx =)

Date &amp; time validation

Date & time validation