G
Garyj
Guest
I have a two text boxes one is called "RWDate" and the other "Warranty" The RWDate is used to enter when an item comes in and the warranty is when the item expires. What I am trying to do is have another field showing the count down between the warranty date and the current date then when it reaches zero stop. I also would like to display a message when the warranty reaches 14 days before expiration and before that display another message.
Example: When the warranty 14 or below a message would display "Your warranty is about to expire within 14 days." and when the warranty is above the 14 day the message would say "This equipment warranty is still in full effect."
I created a text box with this code: =DateDiff("d",Now(),[Warranty])
This code works however it keep counting down and then starts displaying negative numbers.
I created another text box with this code: =IIf([RW2]<=14,"Your warranty is about to expire within 14 days","This equipment warranty is still in full effect")
This code works fine however I would like to read "Your Warranty has expired" when the counter reaches zero.
Any help would be greatly appreciated
Example: When the warranty 14 or below a message would display "Your warranty is about to expire within 14 days." and when the warranty is above the 14 day the message would say "This equipment warranty is still in full effect."
I created a text box with this code: =DateDiff("d",Now(),[Warranty])
This code works however it keep counting down and then starts displaying negative numbers.
I created another text box with this code: =IIf([RW2]<=14,"Your warranty is about to expire within 14 days","This equipment warranty is still in full effect")
This code works fine however I would like to read "Your Warranty has expired" when the counter reaches zero.
Any help would be greatly appreciated
