Hi
Im using IIS5, Win2k, ASP (Jscript)
I have and Access DB with dates stored in one column, the field is defined as text, and date format used is 200404241430 (yyyymmddhhmmss).
The problem is some dates are GMT / UTC and others are GMT+1, all need to be GMT.
I get the field from the db, break up the string and initalize a date object.
Code:
var de = rs("dateStart") +"";
var yy = ""+ de.substring(0,4);
var mm = ""+ de.substring(4,6);
var dd = ""+ de.substring(6,8);
var hh = ""+ de.substring(8,10);
var min = ""+ de.substring(10,12);
var ss = "00"; //none of the dates have seconds so set to zero
var gmtd = Date.UTC(yy,mm-1,dd,hh,min,ss);
var d = new Date(gmtd)
<%=de%>
<%=d.toString();%>
The output is like this:
200304120444
Sat Apr 12 04:44:00 UTC+0100 2003
200302010444
Sat Feb 1 04:44:00 UTC 2003
I do not need the toGMTString() method as I want the date object to be GMT so I can work things out with it, not a string representation.
Can anyone tell me how to force the date object to be GMT.
Thanks
Brad