HOW TO : Assign Date Value to SelectionFormula 
Author Message
 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!!



Thu, 27 Apr 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Syntax Error Assigning date value to FindFirst

2. Assigning a Date field a Null value....

3. Assigning a Date field a Null value....

4. How to assign date value to FILETIME structure

5. Assigning the value to the value of a variable

6. VB and Crystal Report : Selectionformula with date

7. SelectionFormula and Date variable

8. VB and Crystal Report : Selectionformula with date

9. Crystal Reports - Report1.SelectionFormula{Date} ??

10. Value "null" in SelectionFormula

11. Help: Date/Time in SelectionFormula

12. SelectionFormula and dates

 

 
Powered by phpBB® Forum Software