How to compare dates?

[pho01]

What is the right format to compare date in BusinessObject, I tried to create a varable, similar to:


=If([Currently Open].[Incident Closed Date]>"04/30/2008";"May";"")

and
=If([Currently Open].[Incident Closed Date >04/30/2008;"May";"")

Both failed: The expression/sub-expression at position **(where ** is at 04/30/2008) uses an invalid data type. Specify a valid data type. (Error: WIS 10037)

What is right date format i should put in there?

Thanks!

 

[lbass]

Please don't crosspost. Also, can you clarify whether you are using Crystal Reports or Business Objects? There is a separate forum for Business Objects: Business Objects solutions forum393.

-LB

 

[pho01]

sorry, it's business objects. thanks for tips