Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Sql dates and ASP

Author  Topic 

makimark
Starting Member

34 Posts

Posted - 2001-08-13 : 11:38:47
Hi

I'm trying toget this to work. I have a form on which a user selects two dates, one from date (dd/mm/yyyy) and one to date (dd/mm/yyyy). When i insert the dates db(sql7.0, two datetime fields) the date is inserted as 01/01/1900. wassa going on here ?

I use the following asp code
Insert bla bla
dim begin_date, end_date
begin_date = Request.Form("fromday") & "/" & Request.Form("frommonth") & "/" & Request.Form("fromyear")
same for end_date except fromday becomes today, tomonth etc. Insert goes well but date is buggered.

thanks

Markus

   

- Advertisement -