[using Crystal 10 via MS-SQL Server]
I've been asked to add a formula to a report of expected student grade level. The report currently has parameter fields to select those who are in our programs w/in a certain date range. Date of Birth is an available field. Grade 1 would include any child who is six the preceding Feb. 1.
I've found formulas in this forum to calculate age, but the Feb. 1 aspect is throwing me off in calculating grade level.
Thanks for any help.
I've been asked to add a formula to a report of expected student grade level. The report currently has parameter fields to select those who are in our programs w/in a certain date range. Date of Birth is an available field. Grade 1 would include any child who is six the preceding Feb. 1.
I've found formulas in this forum to calculate age, but the Feb. 1 aspect is throwing me off in calculating grade level.
Thanks for any help.