Help w/calculation to find records within a period of time

[adario]

Ugh, I just don't know how to do this. I would like to create a field in which all records are displayed for 5 years prior to today's date.

Please help

tks

Amy

[LaRetta]

Create a calculation called cLastFiveYears (result is date) and make the calculation unstored in Storage options:

Let ( d = Get ( CurrentDate ) ; Date ( Month ( d ) ; Day ( d ) ; Year ( d ) - 5 ) )

Duplicate the occurrence of this table and create a self join, calling the new table occurrence LastFiveYears. Join the occurrences as:

MainFile::cLastFiveYears :less: LastFiveYears::YourDateField

Then create a portal on your layout based upon LastFiveYears table occurrence. Records older than five years from today will automatically drop off the portal every day.

Edited July 9, 2009 by Guest

[adario]

Hi LaRetta,

Sorry I didn't get back to you sooner. I didn't see you post. I'm going to give this a try. I'm not exactly understanding things though, but I'm going to try before I ask more questions.

Thank you so much

Amy