Reputation: 3050

Filtering date in Crystal Reports

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

Upvotes: 1

Answers (3)

Reputation: 2750

MONTH(cDate({Employees.d_o_b})) = 09

Upvotes: 0

Reputation: 3050

Here is the Correct formula

 MONTH(DATE({Employees.d_o_b})) = 09

Upvotes: 3

Reputation: 4696

Try using this

MONTH({Employees.d_o_b}) = "09"

Upvotes: 1