Date Difference in Weeks

[threadgills]

I'm trying to get the number of weeks between 7/2/1997 and 6/8/2004. The code i'm using is what I found here in the forums:

Using DateDiff("ww", 07/02/1997, 06/08/2004) gives me 0.

Any help is appreciated.

 

[BobJacksonNCI]

Access needs date fields identified. Try:

DateDiff("ww", #07/02/1997#, #06/08/2004#)

HTH,
Bob

 

[threadgills]

I had just finished doing that when I checked the post and that was it! Thank you