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

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, 200916 yr by Guest

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