I need to know how to find out the elapsed days between two dates. For
example:
Date Ordered:
Date Shipped:
Days to fulfill order:
If the date shipped is null (order has not been shipped yet) how do I get it
to fill in the current date automatically so that the days to fulfill order
does not come up as an error?

Personally, I would not want to fill in the current date (and give a wrong
number) I would want it to remain blank.

Use an IF statement to say "if shipped is blank don't put anything"



"BetsyK" <(E-Mail Removed)> wrote in message
news:E795C2C1-EEB4-4DB0-88F7-(E-Mail Removed)...
> I need to know how to find out the elapsed days between two dates. For
> example:
> Date Ordered:
> Date Shipped:
> Days to fulfill order:
> If the date shipped is null (order has not been shipped yet) how do I get
it
> to fill in the current date automatically so that the days to fulfill
order
> does not come up as an error?

The Nz function could be used:
Nz([Date Shipped], Date())

--

Ken Snell
<MS ACCESS MVP>

"BetsyK" <(E-Mail Removed)> wrote in message
news:E795C2C1-EEB4-4DB0-88F7-(E-Mail Removed)...
>I need to know how to find out the elapsed days between two dates. For
> example:
> Date Ordered:
> Date Shipped:
> Days to fulfill order:
> If the date shipped is null (order has not been shipped yet) how do I get
> it
> to fill in the current date automatically so that the days to fulfill
> order
> does not come up as an error?

Maybe I should have been alittle clearer, I don't what it to fill in a date
for the date shipped. I want the date shipped to stay open but fill in the
days to fulfill order.

"Rick B" wrote:

> Personally, I would not want to fill in the current date (and give a wrong
> number) I would want it to remain blank.
>
> Use an IF statement to say "if shipped is blank don't put anything"
>
>
>
> "BetsyK" <(E-Mail Removed)> wrote in message
> news:E795C2C1-EEB4-4DB0-88F7-(E-Mail Removed)...
> > I need to know how to find out the elapsed days between two dates. For
> > example:
> > Date Ordered:
> > Date Shipped:
> > Days to fulfill order:
> > If the date shipped is null (order has not been shipped yet) how do I get
> it
> > to fill in the current date automatically so that the days to fulfill
> order
> > does not come up as an error?
>
>
>

I do not want it fill in the Date shipped with the current date, but I do
want the days to fulfill order to be a running total if the product has not
shipped yet.

How do I do that?

"Ken Snell [MVP]" wrote:

> The Nz function could be used:
> Nz([Date Shipped], Date())
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "BetsyK" <(E-Mail Removed)> wrote in message
> news:E795C2C1-EEB4-4DB0-88F7-(E-Mail Removed)...
> >I need to know how to find out the elapsed days between two dates. For
> > example:
> > Date Ordered:
> > Date Shipped:
> > Days to fulfill order:
> > If the date shipped is null (order has not been shipped yet) how do I get
> > it
> > to fill in the current date automatically so that the days to fulfill
> > order
> > does not come up as an error?
>
>
>

Use the expression I gave you in the DateDiff function:

Numberofdays = DateDiff("d", [Date Ordered], Nz([Date Shipped], Date()))

--

Ken Snell
<MS ACCESS MVP>

"BetsyK" <(E-Mail Removed)> wrote in message
news:B65F5830-5E57-4B67-BB67-(E-Mail Removed)...
>I do not want it fill in the Date shipped with the current date, but I do
> want the days to fulfill order to be a running total if the product has
> not
> shipped yet.
>
> How do I do that?
>
> "Ken Snell [MVP]" wrote:
>
>> The Nz function could be used:
>> Nz([Date Shipped], Date())
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>>
>> "BetsyK" <(E-Mail Removed)> wrote in message
>> news:E795C2C1-EEB4-4DB0-88F7-(E-Mail Removed)...
>> >I need to know how to find out the elapsed days between two dates. For
>> > example:
>> > Date Ordered:
>> > Date Shipped:
>> > Days to fulfill order:
>> > If the date shipped is null (order has not been shipped yet) how do I
>> > get
>> > it
>> > to fill in the current date automatically so that the days to fulfill
>> > order
>> > does not come up as an error?
>>
>>
>>