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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying elapsed number of weeks between two dates 1
CalcWorkDays error 1
Decimal places and formatting within query! aargh! 1
Number of days 9
Date Formats-Weeks in Date No 2
Years of Service Calculation to 2 decimal places 7
Date Range Issue 3
date calculation and decimal places 2

Top