AnsweredAssumed Answered

Display records for only x months in the future

Question asked by techt on Dec 3, 2012
Latest reply on Dec 10, 2012 by techt

I have a portal into a set of activities for the user and the client has agreed to limit the number of records displayed to the next 13 months out. I have a working formula, but I've been around FMP long enough to know that things change and there often are new techniques that are developed that I may have missed.

 

The formula is below, does anyone have a cleaner or more concise method for the same function?

 

DueDate <= Date ( (Month ( Get ( CurrentDate ) ) + 13) ; Day ( Get ( CurrentDate ) ) ; Year ( Get ( CurrentDate ) ) )

 

Thanks in advance,

 

Tim

Outcomes