>I am substracting two datetime values which gives a datetime. Now, with that value, I want to convert that in how many days and how many hours. Is there a function somewhere to do that?
No, datetime arithmetic yields results in seconds. So:
lt2 - lt1 = lnSecondsDifference
lnDaysDifference = INT(lnSecondsDifference / 86400)
lnHoursRemainder = (lnSecondsDifference - (lnDaysDifference * 86400)) / 3600
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up