
HOW TO : Assign Date Value to SelectionFormula
Everybody know that?
I've found "date(YY,MM,DD)" function right now.
It take 1 hour to find this fucntion.
Anyway.
If you want to set selection condition on report dynamically,
You must use *SelectionFormula* method(property?).
Especially, If you want to set date condition on report,
resemble the below example.
CrystalReport1.SelectionFormula = "{Transaction.EnterDate} <
Date(1997,11,9)"
CrystalReport1.Action = 1
,where 'Transaction' is a table name, 'EnterDate' is a field name which type
is somewhat date(or time).
Do not use the Date style used in SQL syntax. At leat, CR4.6 doesn't support
that.
Hmm. Hope this helps.
See you later.
ps. I want to buy CR 6!!