passing date from oracle to CR

[couse1]

Hi,

I'm trying to pass a date, this is my code :
Salut,

enreg := 'SelectionFormula = {chrono.code_corr} = '||chr(39)||'ENVIRO'||chr(39)||' and {chrono.date_recu} = date(12/12/2001)'||'\n';

I had my crystal page but without datas!

Does anybody know the code?
thanks
Couse1

 

[synapsevampire]

What's the pipe symbols anbd /n about?

A record selectionj is Crystal syntax, not SQL.

Try:

"{chrono.code_corr} = 'ENVIRO' and {chrono.date_recu} = cdate(2001,12,12)"

Something like that...

-k