Date Calculation

[TracyM via AccessMonster.com]

Hi

I have an unbound box on my form which shows how many days are left between
the dates, 'Project Arrived' and 'Project Required' this works great.

What I want to know is whether I could get this box to stop counting when a
third date, 'project complete' is filled in?

Any advice would be greatly appreciated

Thanks in advance

 

[missinglinq via AccessMonster.com]

In order to help we need to see the code and the code's location that you're
using to do this calculation.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[TracyM via AccessMonster.com]

In order to help we need to see the code and the code's location that you're
using to do this calculation.

This is the code, it is allocated on my project form in the control source of
an 'unbound' field'

=DateDiff("d",Date(),[Date Required])

Thanks

 

[TracyM via AccessMonster.com]

In order to help we need to see the code and the code's location that you're
using to do this calculation.

This is the code, it is allocated on my project form in the control source of
an 'unbound' field'

=DateDiff("d",Date(),[Date Required])

Thanks

Apologies just noticed, it calcuates how many days left from current date to
when date required, this is ok, its the other bit I want to know about

 

[Guest]

I use the IIF function to say if the [ProjectComplete]=* then show "0"
otherwise show [ProjectRequired]-[ProjectArrived]+1.