Rounding Down

[Guest]

I'm trying to round down an expression in a query. This is what I have so
far: Whole Weeks: (Now()-[Start Date])/7. This will give me the number of
weeks (e.g. 2.6) but I need it to return the result rounded down (e.g. 2.0).

Dave

 

[Guest]

Hi,

Try this:

Whole_Weeks: DateDiff("w",Now(),[Start Date])

This link should explain it for you(watch out for wordwrap)....

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vafctdatediff.asp

hth

rpw

 

[Van T. Dinh]

Try:

Int((Date() - [Start Date])/7)