I did just do the math myself and it worked fine.
((Date_Time1 - Date_Time2) - (Days * 86400)) /60 /60
My concern was that HOURS() worked differently than MINUTES() or SECONDS()
Which worked as I expected.
The results and how they worked is inconsistent, which was why I posed the
question.
Hi,
No, it is not inconsistent.
Seconds are seconds regardless of date, your timezone, daylighsavingstime,
etc.
Hours depend on all these things.
The date is stored as the number of seconds since 1970-01-01 00:00:00 GMT.
By doing the math (Date_Time1 - Date_Time2), you revert to 1970-01-01,
to help.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Friday, April 01, 2011 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: HOURS function doesnt appear to work correctly-CLOSED
Hi
.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Friday, April 01, 2011 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: HOURS function doesnt appear to work correctly-CLOSED
Hi,
No, it is not inconsistent
4 matches
Mail list logo