>>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
Thanks also, I got two answers at the same time. :)