>>>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.
Whoops, should be:
days = INT(seconds/86400)
hours = INT((seconds-86400*days)/3600)