RE: FN-FORUM: ASP suckery

date posted 5th January 2007 12:59

>>If you response.write(oRs.Fields("daDespatchDate")) what do you get back,
>>check it is a valid date format.

I get nothing at all ;-( but that does work for the created date, so it MUST
be something to do with how I'm getting the data. But since its done in the
same way for each , I cant see what it is,


I KNOW the data is there...

Create date despatch date
2006-12-19 12:32:53.873 2006-12-20 00:00:00.000
2006-12-20 06:19:40.640 2006-12-20 00:00:00.000
2006-12-20 10:31:49.653 2006-12-20 00:00:00.000
2006-12-20 11:57:12.390 2007-01-03 00:00:00.000

Looking at the enterprise manager, I can see that both are stored as
datetime 8 (I assume the length is ignored, since both are clearly longer)

I'll give the function a whirl as well, but as the data I start with seems
to be blank, im not sure how much use that will be.

D