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,