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,