determine number of weeks between 2 date with decimal

Q

Question Boy

How can I determine number of weeks between 2 date with decimal precision.

let say if the was a delta of 6 day between 2 date return 6/7 = 0.86

I tried the DateDiff("ww",.....) but it return whole number not decimal as I
require in this instance.

Thank you,

QB
 
M

Marshall Barton

Question said:
How can I determine number of weeks between 2 date with decimal precision.

let say if the was a delta of 6 day between 2 date return 6/7 = 0.86

I tried the DateDiff("ww",.....) but it return whole number not decimal as I
require in this instance.
Click to expand...


Does this work for you?

DateDiff("d", date1, date2) / 7
 
Top