Day count

[capogna1]

Hi everyone!
I have a field in a form that calculates Days Old and it's in Control source: =DateDiff("d",[Discharge_Date],Date())
I need an easy way to stop this when the task is completed so it stops counting the days.
A completed button or checkbox anything that will work.
Thanks in advance.
Robert

 

[theDBguy]

How do you know the task is completed? Is there a Task_Completed_Date field?

 

[capogna1]

How do you know the task is completed? Is there a Task_Completed_Date field?

No I currently don't have that, but good idea. I was thinking a competed button for it to stop counting. But I can add a Completed date field and how to I tell to stop using Date() and stop counting? Cause if it's complete it should count from the day completed to the [Discharge_Date]

 

[Eugene-LS]

Control source: =DateDiff("d",[Discharge_Date],Date())

With [CompletedDate] field:
Control source: =DateDiff("d",[Discharge_Date], Nz([CompletedDate], Date()))

 

[capogna1]

With [CompletedDate] field:
Control source: =DateDiff("d",[Discharge_Date], Nz([CompletedDate], Date()))

Thanks so much!

 

[capogna1]

Thanks so much!

It works Yeahhh!!! TY again