counting weeks between 2 dates

[Guest]

Hi, I'm newbie at access, so can I ask some questions here?
I'm having trouble with how to count weeks between 2 dates and second
question is those 2 dates one of them coming from typing, but the other date
needs to generated by subtract the typed date by 9 months. Any suggestions
how am I suppose to do?
thanks before

dwin

 

[JK]

Dwin

NumWeeks = DateDiff("ww", [YourTypedDate], DateAdd("m", -9,
[YourTypedDate]))

Regards/JK

 

[Guest]

sorry I'm a total newbie, but where should I put that code? Thanks and sorry

Dwin

NumWeeks = DateDiff("ww", [YourTypedDate], DateAdd("m", -9,
[YourTypedDate]))

Regards/JK

Hi, I'm newbie at access, so can I ask some questions here?
I'm having trouble with how to count weeks between 2 dates and second
question is those 2 dates one of them coming from typing, but the other
date
needs to generated by subtract the typed date by 9 months. Any suggestions
how am I suppose to do?
thanks before

dwin

 

[JK]

Dwin

It occurred to me after I posted.
You don't need any code - the result will *always* be 39 weeks. Your
question, as it stands, is like asking how many days elapse between a date
and 2 days earlier.

Perhaps you can rephrase your question.

Regards/JK

sorry I'm a total newbie, but where should I put that code? Thanks and
sorry

Dwin

NumWeeks = DateDiff("ww", [YourTypedDate], DateAdd("m", -9,
[YourTypedDate]))

Regards/JK

Hi, I'm newbie at access, so can I ask some questions here?
I'm having trouble with how to count weeks between 2 dates and second
question is those 2 dates one of them coming from typing, but the other
date
needs to generated by subtract the typed date by 9 months. Any
suggestions
how am I suppose to do?
thanks before

dwin