>>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?
>
>Two datetimes gives you a result in seconds, not a datetime.
>
>seconds = datetime1 - datetime2
>
>days = INT(seconds) / 86400
>
>hours = INT(seconds-86400*days) / 3600
Thanks for the clarification
I'll use that logic.