Hello,

I'm wondering which could be the easiest way to convert the delta between two dates into days, without any mention of hours, minutes, and so on.

Typical result format I get when subtracting 2 dates is : **26**.02:59:00.9090159 (26 days, 2 hours, 59 minutes, etc...)

I thought playing with InStr function to find the position of the first dot and then extract only the left portion but I think that there could a much smarter and cleaner way to proceed.

Thanks in advance for your answers,

David

Just an idea... convert this to seconds.

After that convert this seconds (WT is working time in seconds) to days:

concat(format(int(WT/86400),"%2.2d","I"), "d" )

Regards,

Igor