Kurt Knippel Posted October 12, 2000 Share Posted October 12, 2000 quote: Originally posted by partsgb.martinw: In my Solution i would like to create the following field. I have a field called " Fax Date " ( Date Field ). In 60 days time this fax will have expired. What i would like to do is when the field has expired that it would paste the following words into another field "EXPIRED" FaxStatus = Case ( Status(CurrentDate) > FaxDate + 60, "Expired") You can also add whatever else to this that you want for other status identifications. Make sure to set the calculation as UNSTORED, so that it will evaluate the Status(CurrentDate) everytime. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Consultant Database Resources mailto:[email protected] http://www.database-resources.com =-=-=-=-=-=-=-=-=-=-=-=-= Link to comment Share on other sites More sharing options...
partsgb.martinw Posted October 13, 2000 Share Posted October 13, 2000 In my Solution i would like to create the following field. I have a field called " Fax Date " ( Date Field ). In 60 days time this fax will have expired. What i would like to do is when the field has expired that it would paste the following words into another field "EXPIRED" What would be the best way to do this.. Many Thanks, Martin Link to comment Share on other sites More sharing options...
partsgb.martinw Posted October 22, 2000 Share Posted October 22, 2000 quote: Originally posted by captkurt: FaxStatus = Case ( Status(CurrentDate) > FaxDate + 60, "Expired") You can also add whatever else to this that you want for other status identifications. Make sure to set the calculation as UNSTORED, so that it will evaluate the Status(CurrentDate) everytime. Hi Kurt, I have tried doing this in my solution and the problem is that if FAXDATE is empty the end result is "expired" what do i need to over come this problem. maybe an ISEMPTY statement... Many Thanks, Martin Link to comment Share on other sites More sharing options...
Kurt Knippel Posted October 22, 2000 Author Share Posted October 22, 2000 quote: Originally posted by partsgb.martinw: I have tried doing this in my solution and the problem is that if FAXDATE is empty the end result is "expired" what do i need to over come this problem. maybe an ISEMPTY statement.../B] Exactly. Try: FaxStatus = Case (IsEmpty ( FaxDate ), "", Status(CurrentDate) > FaxDate + 60, "Expired") This should solve the problem. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Consultant Database Resources mailto:[email protected] http://www.database-resources.com =-=-=-=-=-=-=-=-=-=-=-=-= Link to comment Share on other sites More sharing options...
partsgb.martinw Posted October 22, 2000 Share Posted October 22, 2000 quote: Originally posted by captkurt: Exactly. Try: FaxStatus = Case (IsEmpty ( FaxDate ), "", Status(CurrentDate) > FaxDate + 60, "Expired") This should solve the problem. Hey Hey, Works Great, Many Thanks Kurt. Just one more problem if you could help me on. After 75 days i would like this field to have nothing in it. What will i need to do :? Many Thanks, Martin Link to comment Share on other sites More sharing options...
LiveOak Posted October 22, 2000 Share Posted October 22, 2000 FaxStatus = Case( IsEmpty ( FaxDate ), "", Status(CurrentDate) > FaxDate + 75, "", Status(CurrentDate) > FaxDate + 60, "expired", "" ) -bd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8594 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