Convert number of weeks to a date

[linmatt]

I need to have a small sub-form in Access 2000 that I can enter a date, and a number of weeks, and have the date at the end of that number of weeks for a subscriptions database. The idea is that I enter the date they want it to start (default today =Now()) and the number of weeks they want. I can then run a query/report to print the address labels, and after the end date they stop automatically. Clever, init? That bit works fine. The first bit don't.

I had 2 fields, "date1" and "weeks", and a 3rd with something like "=[date1]+([weeks]*7]", with the field formatted as date, but it doesn't want to play. Can anyone suggest an alternative?

Many thanks

Matt

 

[dab3141592]

You can try using :

DateAdd( "ww", weeks, date1 )

 

[MichaelRed]

Actually, your original expression only contains a minor syntax error:


Orig - W/ error
"=[date1]+([weeks]*7]"

Corr - w/ Change
"=[date1]+([weeks]*7)"

Although dab(N) does give the more formal syntax prefered by MS afectionados.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over