NickDenyer
Registered User.
- Local time
- Today, 19:41
- Joined
- May 2, 2012
- Messages
- 57
Hi all!
Recently got some help with the following code (thank you arnelgp!):
=IIf(Date()-30-[Field1]<0,Abs(Date()-30-[Field1]) & " Days before approval","30 days target has elapsed")
This allowed me to develop a reliable countdown timer based on a date set in Field1. Users enter a date and have 30 days to complete the whole form. However, I want this 30 day timer to stop once data (date) has been entered into another field (Field2), displaying a message such as "30 day target achieved".
Any ideas on manipulating the expression above?
Thank you!
Recently got some help with the following code (thank you arnelgp!):
=IIf(Date()-30-[Field1]<0,Abs(Date()-30-[Field1]) & " Days before approval","30 days target has elapsed")
This allowed me to develop a reliable countdown timer based on a date set in Field1. Users enter a date and have 30 days to complete the whole form. However, I want this 30 day timer to stop once data (date) has been entered into another field (Field2), displaying a message such as "30 day target achieved".
Any ideas on manipulating the expression above?
Thank you!