KassK Posted September 28, 2016 Posted September 28, 2016 Hi I am hoping someone can help me to do the below. I have two fields 1 "Letter Sent" field(date) and 2 "Letter Received" field (date). I would like the "Letter Received" field to go red if no dated entered 7 days after the date entered in "Letter Sent" field. I hope that makes sense.
comment Posted September 28, 2016 Posted September 28, 2016 (edited) Try: YourTable::Sent and not ( Self ) and Get ( CurrentDate ) > YourTable::Sent + 7 Edited September 28, 2016 by comment
KassK Posted September 28, 2016 Author Posted September 28, 2016 Thanks for this the field "Letter Received" field is red to begin with is there a way to have this not be red to start with?
comment Posted September 28, 2016 Posted September 28, 2016 2 hours ago, KassK said: "Letter Received" field is red to begin with You mean when the Sent field is empty? Try the edited version above.
KassK Posted September 28, 2016 Author Posted September 28, 2016 your awesome, thank you so very much
Recommended Posts
This topic is 3262 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now