Add dates within date ranges

[Guest]

Hi

HELP!! HELP!

We have an [OrderDate] and a [TargetDate] but they are not fixed
eg
03/05/2004 - 07/05/200
and 05/05/2004 - 10/05/200
and 12/05/2004 - 14/05/2004

How can we calculate the amount of days needed. (The answer should be 9 days excluding weekends

 

[Ed Robichaud]

I assume you mean that you need to calculate the calendar date that is 9
days later than the entered [OrderDate] /or [TargetDate]. The expression
"=[OrderDate]+9" will do just that, (adding nine days to whatever value is
entered for [OrderDate], but you'll need the DateAdd function (see Access
help) to add just weekdays.
-Ed

 

[Guest]

Hi

What we need is to calculate the first date range (03/05/2004 - 10/05/2004) and then the second range (12/05/2004 - 14/05/2004).
eg
03/05/2004 - 07/05/200
and 05/05/2004 - 10/05/200
and 12/05/2004 - 14/05/2004

Any Ideas?


----- Ed Robichaud wrote: ----

I assume you mean that you need to calculate the calendar date that is
days later than the entered [OrderDate] /or [TargetDate]. The expressio
"=[OrderDate]+9" will do just that, (adding nine days to whatever value i
entered for [OrderDate], but you'll need the DateAdd function (see Acces
help) to add just weekdays
-E

Hi

HELP!! HELP!
We have an [OrderDate] and a [TargetDate] but they are not fixed

eg
03/05/2004 - 07/05/200
and 05/05/2004 - 10/05/200
and 12/05/2004 - 14/05/2004

How can we calculate the amount of days needed. (The answer should be days excluding weekends

 

[Ed Robichaud]

It would be the same technique. [Range] = between[OrderDate]+9 and
[OrderDate]+14
Still not sure I understand what you're trying to do.
-Ed

Hi,

What we need is to calculate the first date range (03/05/2004 -

10/05/2004) and then the second range (12/05/2004 - 14/05/2004).

eg.
03/05/2004 - 07/05/2004
and 05/05/2004 - 10/05/2004
and 12/05/2004 - 14/05/2004.

Any Ideas??


----- Ed Robichaud wrote: -----

I assume you mean that you need to calculate the calendar date that is 9
days later than the entered [OrderDate] /or [TargetDate]. The expression
"=[OrderDate]+9" will do just that, (adding nine days to whatever value is
entered for [OrderDate], but you'll need the DateAdd function (see Access
help) to add just weekdays.
-Ed

Hi,

HELP!! HELP!!
We have an [OrderDate] and a [TargetDate] but they are not fixed,

eg:
03/05/2004 - 07/05/2004
and 05/05/2004 - 10/05/2004
and 12/05/2004 - 14/05/2004.

How can we calculate the amount of days needed. (The answer should

be 9
days excluding weekends)

 

[Guest]

For stats purposes we need to calculate the actual days USED between [OrderDate] & [TargetDate] and between [StartDate] & [EndDate]. The problem of this is it calculates the full date range and not the actual days used

eg. 03/05/2004 - 07/05/200
05/05/2004 - 10/05/200
12/05/2004 - 14/05/200

The way it works now it calculates the amount days from the 03/05/2004 to the 14/05/2004 but we need to calculate dates 03/05/2004 to 10/05/2004 (as the dates overlap with each other) and then the 12/05/2004 to 14/05/2004 as there were no orders between the 10th and the 12th, so these dates should be excluded. Hope this helps

Is this even possible?

----- Ed Robichaud wrote: ----

It would be the same technique. [Range] = between[OrderDate]+9 an
[OrderDate]+1
Still not sure I understand what you're trying to do
-E

Hi

10/05/2004) and then the second range (12/05/2004 - 14/05/2004)

eg
03/05/2004 - 07/05/200
and 05/05/2004 - 10/05/200
and 12/05/2004 - 14/05/2004

Any Ideas?
I assume you mean that you need to calculate the calendar date tha

is
days later than the entered [OrderDate] /or [TargetDate]. Th expressio
"=[OrderDate]+9" will do just that, (adding nine days to whateve value i
entered for [OrderDate], but you'll need the DateAdd function (se Acces
help) to add just weekdays
-E

Hi
HELP!! HELP!
We have an [OrderDate] and a [TargetDate] but they are not fixed

eg
03/05/2004 - 07/05/200
and 05/05/2004 - 10/05/200
and 12/05/2004 - 14/05/2004

How can we calculate the amount of days needed. (The answer shoul

be
days excluding weekends