i am trying to filter date by month in Crystal Reports Formula but its not working Here is the Formula
{Employees.d_o_b} = "yyyy-09-dd"
in database date is saved in this format
2013-09-29
in a Date type filed i am using Sql Server 2008 and Crystal Reports 11
Here is the Correct formula
MONTH(DATE({Employees.d_o_b})) = 09