Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Date > 60 Days


This topic is 8776 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

  • 2 weeks later...

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

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

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

This topic is 8776 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.