I have two date fields, one startTime, and the other endTime. The times
occur in the same day. I want to calculate the value of the differences as
hours, for example 3:30 PM - 2:00 PM = 1.5 hours. I can't find a way to
calculate this. I'm new to manipulation XML and JScript. Any help would be
appreciated.
Thanks,
John
The Data Validation sample in the SDK has some examples of
calculations involving dates and times.
[from Steve VD]
Mathmatical operations involving two time values don't make much sense
IMHO. Usually it's a time +/- an offset like X hours or something.
But, here goes:
var dom = XDocument.DOM;
var t1 = dom.selectSingleNode("my:myFields/my:time1").nodeTypedValue;
var t2 = dom.selectSingleNode("my:myFields/my:time2").nodeTypedValue;
var t = null;
if (t1.match(/T(\d\d):(\d\d):(\d\d)/))
t1 = Number(RegExp.$1)*3600 + Number(RegExp.$2)*60 +
Number(RegExp.$3);
else
XDocument.UI.Alert("Time 1 is invalid.");
if (t2.match(/T(\d\d):(\d\d):(\d\d)/))
t2 = Number(RegExp.$1)*3600 + Number(RegExp.$2)*60 +
Number(RegExp.$3);
else
XDocument.UI.Alert("Time 2 is invalid.");
t = t1 + t2;
var h = Math.floor(t / 3600);
var m = Math.floor(t % 3600 / 60);
var s = t % 60;
t = String(h + ":" + m + ":" + s).replace(/\b(\d)\b/g, "0$1");
XDocument.UI.Alert(t);
This question has been asked in this newsgroup before, so you may find
additional information by doing a search of this group.
--josh bertsch
> I have two date fields, one startTime, and the other endTime. The times
> occur in the same day. I want to calculate the value of the differences as
[quoted text clipped - 5 lines]
>
> John
Matthew Blain \(Serriform\) - 05 Oct 2004 02:55 GMT
If you create a JScript Date object, you can subtract them--a Date object as
a number is an offset in milliseconds from a particular point in time, so
the difference between two Date objects will be the elapsed time.
--Matthew Blain
http://tips.serriform.com/
http://www.microsoft.com/mspress/books/7128.asp
> The Data Validation sample in the SDK has some examples of
> calculations involving dates and times.
[quoted text clipped - 44 lines]
> >
> > John