date time

[brino]

hi all !

i am doing a query to calculate the difference between a time in a
field and the present date/time.
the problem is its producing the result as a decimal value of a day.
how can i get it to produce the result in days & hours ??


thanks
brino

 

[Arvin Meyer [MVP]]

I think you'll find you answer in this Microsoft Knowledge Base article:

http://support.microsoft.com/kb/130514/en-us
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Alessandro Baraldi]

brino ha scritto:

hi all !

i am doing a query to calculate the difference between a time in a
field and the present date/time.
the problem is its producing the result as a decimal value of a day.
how can i get it to produce the result in days & hours ??


thanks
brino

You need a function, with DateDiff you can get the difference in Hours
or days....!
If you want Days and Hours you need also 2 Field:

So if you can get Total Hours with DateDiff and
TotHours=DateDiff("h".....)
HoursInDays=Hour\24 ----> or INT(Hours/24)
Hours=TotHours-HoursInDays

@Alex