I created a parameter called birthmonth which has the two digit number of each month of the year like 01, 02, 03, to 12. This parameter is used to filter a date field in the report. When I use the select expert record selection formula editor with the forumula below I keep getting "A date is required here". Not sure where my syntax is wrong. Any help is appreciated.
date(month({date_of_birth})) = {?birthmonth}
I even tried cstr(date(month({date_of_birth}))) = {?birthmonth} but the report is blank.
FIX:
This works after I changed the parameter values to the month names like January, February, etc..
monthname(month({date_of_birth})) = {?birthmonth}
Edited by phoeneous - 04 Nov 2010 at 9:53am
IP Logged