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

=-=-=-=-=-=-=-=-=-=-=-=-=

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

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

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

=-=-=-=-=-=-=-=-=-=-=-=-=

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

FaxStatus =

Case(

IsEmpty ( FaxDate ), "",

Status(CurrentDate) > FaxDate + 75, "",

Status(CurrentDate) > FaxDate + 60, "expired",

""

)

-bd