Data comparison in crystal reports?

how to compare dates in crystal reports' selection formula.

I want to apply selection criteria on my crystal report.
Report is binded to a data view.
and i m doing like this

CRViewer.SelectionFormula = "{v_advances.creationDate} > '2/2/2004'"

v_advances= database view name
creationDate= view's field's alias name

and its not working.

kindly tell me; how to compare dates in selection formula of crystal report.Use Date(yr,mon,day) format

i.e, {table.field} < Date(2004,4,1)

Otherwise pass a date parameter, check with that parameter name.

Hope this will work|||its not working :(

what if i compare the view field with a parameter?

how to compare that.

:confused:|||Hi,

I'm not clear. What's view field. Is it ur database field. If it's use the folg.

{table.field} > {?Date}|||field is alias of db field in view.|||Then simply select the field, operator(like >,<),parameter field(Should be date datatype)