Calculate number of weeks

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I use Access 2003. I have start and finish dates, and want to calculate the
number of weeks in a separate text box. I have tried the following:

=[Hire Ends]-[Hire Start]/7

This does not work.

Any help??

Thanks
Matt.
 
If you want the subtraction to occur before the division, you need brackets:
= ([Hire Ends] - [Hire Start]) / 7
 
Also Datediff is better for this sort of thing

Pieter

Allen Browne said:
If you want the subtraction to occur before the division, you need
brackets:
= ([Hire Ends] - [Hire Start]) / 7

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Matt said:
I use Access 2003. I have start and finish dates, and want to calculate
the number of weeks in a separate text box. I have tried the following:

=[Hire Ends]-[Hire Start]/7

This does not work.

Any help??

Thanks
Matt.
Click to expand...
Click to expand...
 
I use Access 2003. I have start and finish dates, and want to calculate the
number of weeks in a separate text box. I have tried the following:

=[Hire Ends]-[Hire Start]/7
Click to expand...

Try

DateDiff("ww", [Hire Start], [Hire Ends])

John W. Vinson[MVP]
 
Back
Top