Print Page | Close Window

*RESOLVED* date(month({date})) = {?parameter}

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11597
Printed Date: 02 May 2025 at 5:50pm


Topic: *RESOLVED* date(month({date})) = {?parameter}
Posted By: phoeneous
Subject: *RESOLVED* date(month({date})) = {?parameter}
Date Posted: 04 Nov 2010 at 8:55am
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}


Print Page | Close Window