Hi,

  I have two drop down boxes one is for month & one is for date.I want 

that both of these values should go into the database where i have a 

single field called date1 which is of type date/time.it has to store both 

these values.

 can anyone help me how to do it.

I am using ACCESS-2000.

strDate = Year() & "/" & Request.Form("chkMonth") & "/" &

Request.Form("chkDay)



If isDate(strDate) then

    ' Date is OK, insert into database

Else

    ' We have an invalid date, eg 31st February

End If



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "urmilla" <urmi_tikoo@m...>

Subject: [access_asp] how to insert date from drop down into database





: Hi,

:   I have two drop down boxes one is for month & one is for date.I want

: that both of these values should go into the database where i have a

: single field called date1 which is of type date/time.it has to store both

: these values.

:  can anyone help me how to do it.

: I am using ACCESS-2000.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

>From: "urmilla" <urmi_tikoo@m...>

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

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

>Subject: [access_asp] how to insert date from drop down into database

>Date: Thu, 7 Feb 2002 06:04:05

>

>Hi,

>   I have two drop down boxes one is for month & one is for date.I want

>that both of these values should go into the database where i have a

>single field called date1 which is of type date/time.it has to store both

>these values.



To insert both of these values into database you will need to append year to 

that.

So for example

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



Or otherwise simply make to different Column

Ok.

thanks





D.Ganesh

Mumbai



_________________________________________________________________

Join the world?s largest e-mail service with MSN Hotmail. 

http://www.hotmail.com