determine number of weeks between 2 date with decimal

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Question Boy - 24 Apr 2008 22:57 GMT

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

Reply to this Message

Marshall Barton - 24 Apr 2008 23:37 GMT

>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.

Does this work for you?

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

Signature

Marsh
MVP [MS Access]

Reply to this Message

Question Boy - 25 Apr 2008 00:08 GMT

Marshall,

I feel so stupid right now!

QB

> >How can I determine number of weeks between 2 date with decimal precision.
> >
[quoted text clipped - 6 lines]
>
> DateDiff("d", date1, date2) / 7

Reply to this Message