Jump to content

Calculating "Due Date" and using in relationship?

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

Recommended Posts

Been struggling with a good way to do two simple things that seem diamettrically opposed?

Each record in my database has a calculation field which determines REC_STATUS. This REC_STATUS calculation determines if the Get (CurrentDate) > Target Date (i.e.... has the date passed?)

It seems that the only way to make this update automatically, is to not index it, and mark it as Do Not Store Calc Results - Calc When Needed.

Problem with that though is that I have a self-join relationship for a portal based on a filter by the REC_STATUS.

i.e. global Filter Status = REC_STATUS

Thus REC_STATUS needs to be indexed for the filtered view. And then the calc fields doesn't automatically update.

Is there a smooth way around this that will get me both the filtered record view, and an automatically updating REC_STATUS based on current date?

I have considered some kludgy solutions (manually updating when the database is open or a record is viewed?), but definitely feel like there must be something better.

Thanks for any help!


Link to comment
Share on other sites

This topic is 6810 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.