vb crystal reports selection formula with date

[SN082]

Hello , I have a problem selectioning records with the selectionformula, I allways get an error message "ERROR IN FORMULA" when I try to select records on a valid date variable.
My standard date format is dd-mm-yy and i suppose that the problem lies with Crystal reports, who only mention yyyy-mm-dd in their help section. Can anybody help me with this issue?
btw, I use Crystal reports 4.5, delivered with vb5...
thanks,
stijn

sv

 

[chelseatech]

Your formula needs to use the Date function

CR.ReplaceSelectionFormula= _
"{table.datefield}=Date(2002,3,20)"
Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[SN082]

Thanks for your reply, but I still have a question,
the date I would use is a variable, would this code also work?
CR.ReplaceSelectionFormula= _
"{table.datefield}=Date(VarDATE)"

thanks in advance,

Stijn

 

[y4916]

hello I want convert date to character in crystal report in version 7. that is in crystal report i placed date field in character format but i can not do it how can i do it please help me.
thanks
yunus