Calculating Date by x # of weeks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to figure out how to calculate a date "x" number of weeks in the
future. I've got a "Date Won" field that I want to multiply by "# of Weeks to
Complete." For example, Date Won = 04/03/2006. # of Weeks to Complete = 3.
The result of the equation should = 04/24/2006. Please help...
 
Take a look at the DateAdd() function. Access HELP has the syntax you'll
need.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Alas...the plot sickens. Nice to know I was on the right track.
Unfortunately, when I use =DateAdd(ww",[# of Weeks to Complete}, date()) I
get the right answer. But the field entry is not moving over to the related
table of data. When I build a formula in Expression Builder «Expr» [Date
Won/Started] * [# of Weeks to Complete], I know I'm getting the wrong answer
but the result of the equation does appear in the related table. I'm working
 
If you have a [DateWon/Started] and a [# of Weeks to Complete], you don't
need to store any calculated value. And there are good reasons not to.

Instead, use a query to return the calculated value, using these two stored
values.

Or am I missing something here...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Giggly4g said:
Alas...the plot sickens. Nice to know I was on the right track.
Unfortunately, when I use =DateAdd(ww",[# of Weeks to Complete}, date()) I
get the right answer. But the field entry is not moving over to the
related
table of data. When I build a formula in Expression Builder «Expr» [Date
Won/Started] * [# of Weeks to Complete], I know I'm getting the wrong
answer
but the result of the equation does appear in the related table. I'm
working
on a database created by someone else (who is unavailable). This is the
only
change that is stumping me. Any words of wisdom, oh great mvps?

Jeff Boyce said:
Take a look at the DateAdd() function. Access HELP has the syntax you'll
need.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
Click to expand...
 
Back
Top