adding time 1

[tziviak]

I have a time/date field in access and a text field for minutes
how do I add them both-using asp?
I tried:

var Total=Math.abs(oRs("TotalSessionDuration&quot)
var EndTime=oRs("TimeSessionStarted&quot + (Total*60*1000)

TimeSessionStarted-is the time field & TotalSessionDuration is the text field

I'd appreciate help-since I'm pretty much new to these things
Thank you

 

[onpnt]

are you coding your apges in jscript?

if not might want to look into the DateAdd function _________________________________________________________
for the best results to your questions: FAQ333-2924
_{01001111 01101110 01110000 01101110 01110100}

http://www.onpntwebdesigns.com

[/sub]

 

[palbano]

>> oRs("TimeSessionStarted&quot
Fisrt, that returns a reference to a ADO.Field object so you can’t add anything to it.
oRs("TimeSessionStarted&quot + ( 10)
not going to work

var Total=Math.abs(oRs("TotalSessionDuration"));
var dt = new Date(oRs(“TimeSessionStarted));
var mills = dt.valueOf() + (Total*60*1000);
dt = new Date( mills);

does that help?
-pete

 

[tziviak]

thanks -I used the DateAdd function-and it works great!
thanks for everyone's help