Custom Date Range Parameter

[Former Member]

Post Author: crystalmn

CA Forum: Crystal Reports

Using Crystal Reports XI is it possible to customize the date range parameter to only pull month and date and not look at the year? I want to use it to pull Employee Birthdays out of our GP database but it looks at the year as well.

Thanks!

[Former Member]

Post Author: SKodidine

CA Forum: Crystal Reports

Try this in your record selection:

totext({table.birthdate},"MMdd") intotext(minimum({?DateRange Parameter}),"MMdd") to totext(maximum({?DateRange Parameter}),"MMdd")

This should give you all matching birth days that fall between the date range parameter excluding the year.