FN-FORUM: ASP suckery

date posted 5th January 2007 12:13

I'm more of a PHP bod, but needs must and all that, so I'm looking at an ASP
(classic) site for a client. I hasten to add, that I didn't write this site
myself, and I have no idea if it's the APS that sucks, or the original
programmer who sucks, but clearly something isn't right.

The code is getting some data from SQL server database - dates in this
instance.

Here's the relevant code, the bits I've removed are just to do with the
other fields that aren't relevant.

szSQL = "SELECT * "
szSQL = szSQL & "FROM SPJobs "
szSQL = szSQL & "WHERE ( SPJobs.daCreateDate >= '" & Month(strFromDate) &
"/" & Day(strFromDate) & "/" & Year(strFromDate) & " 00:00' "
szSQL = szSQL & "AND SPJobs.daCreateDate

 
 There are no items. 
 










The problem is that while daCreateDate works fine and comes out in the
proper format. daDespatchDate always comes out as 30/12/1899 ( I suspect
this is a default date for date objects ?) I note the format is correct, but
the date isn't. Both columns do have data, both are stored as the same kind
of date format.

Any clues.