FAQ 63: Grid--Creating a grid to list employees entering during the plan year

Problem: I created a grid, but I want to select participants entering the plan the current plan year. I used ENTRY>$DATE(12;31;2002) AND ENTRY<$DATE(12;31;2003) in the formula expression. How can I use the default plan years specified for each plan? I tried using the VALDATE and PLNYRBEG items, but is not working.

Solution: Assuming that you want to create a formula that you can use that will use the dates from the plan specs, rather than hard-coding the dates, change your formula to the following to list only those employees that entered during the current plan year: (ENTRY>=S:PLNYRBEG)AND(ENTRY<=S:VALDATE)