Countdown days

[dcollard23]

Hi,

I have a form that calculates a target date based on the type of transaction chosen and the effective date that is entered( it can vary).
The target date is displayed on my form as a as a date and a number. How many days between the current date(todays date) and target date I have to complete the transaction(I did not exclude weekends and holidays). So I have Sla: Due in X Days. What I am looking to do is to count down the number of days I have left to completed this transaction.(name of the field would be days to completed). So say I have a target date of 7/29/09 and todays date is 6/29/09 then I want this field to show that I have 30 days to complete this transaction and then tomorrow it will show that I have 29 days to complete this transaction. Now say that I enter a completed date of 6/30/09. The countdown will stop. So it will countdown until a completed date is entered. then the countdown will stop. I have a current date field.

Thanking you in advance for your assistance

 

[jjturner]

Set Control Source for [txt_Days_Left_to_Completion]: = IIf(Date()<[Target_Date], DateDiff("d", Date(), [Target_Date]), "Already Completed")

 

[dcollard23]

Thanks for answering my post.
It is working so far. I am going to add some data to my table and see if it count down tomorrow. Thank you so much for your assistance. It is greatly appreciated.