Date Ranges at run time

[RogerZett]

I have been working on this for longer than I care to tell anyone. I have a database with a date field that I want to select only records meeting a selected date criteria. It seems that this should work but I recieve an " error in formula" when trying to run.

Report1.SelectionFormula = "{QryXXX.Date} = " & ddate

thaks in advance for the help.

Rog

 

[kenhamady]

You have to give Crystal a string that folows Crystal Syntax, which depends on the data type for the field {QryXXX.Date}.

If this is a date field (not a datetime or datetimestring) the syntax for today is:

"{QryXXX.Date} = date(2000,9,26)"

[sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]

 

[ezrog]

How can I then use a date variable as the selection criteria?

Thanks again [sig][/sig]

 

[kenhamady]

You have to convert the date value to text, substring out the appropriate 3 values, and then reassemble them into a string that follows the Crystal Syntax. [sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]