hi all



i have a form and i can validate the date that is entered in the blank 

form. the problem i have is the database field needs to be in date/time 

format to allow queries on dates.

when the edit button is used the date field turns to this long date.

Wed Dec 12 00:00:00 UTC 2012.



how do i validate the date from the database ?

any help will be greatly appriciated.



cheers karl



i've setting the date field in the database to short date but no luck.



i'm using (sql server database which has a connection to access 97) access 

will be used to query sql server db). 

Hi,



1) To check the day use Day (Date)

2) To check the month use Month(Date)

3) To check the year use Year(Date)

4) To get the date it normal format use

Month(Date)&"/"&Day(date)&"/"&year(date)



With Regards,

R. Sathish Kumar.

sathish297@y...





----- Original Message -----

From: "karl hammett" <karl.hammett@b...>

To: "Access ASP" <access_asp@p...>

Sent: Tuesday, January 22, 2002 2:39 PM

Subject: [access_asp] dates





> hi all

>

> i have a form and i can validate the date that is entered in the blank

> form. the problem i have is the database field needs to be in date/time

> format to allow queries on dates.

> when the edit button is used the date field turns to this long date.

> Wed Dec 12 00:00:00 UTC 2012.

>

> how do i validate the date from the database ?

> any help will be greatly appriciated.

>

> cheers karl

>

> i've setting the date field in the database to short date but no luck.

>

> i'm using (sql server database which has a connection to access 97) access

> will be used to query sql server db).




$subst('Email.Unsub').







_________________________________________________________



Do You Yahoo!?



Get your free @yahoo.com address at http://mail.yahoo.com