Error in formula!!!! 1

[Alira]

Hi all!

I don't get it...
For another report it works perfectly...
What could be the problem?

Dfrom = Format(Dfrom, ("yyyy,mm,dd&quot)
Dto = Format(Dto, ("yyyy,mm,dd&quot)

repC.SelectionFormula = "{Module_time.Ship Date} in Date (" & Dfrom & &quot to Date (" & Dto & &quot"

The name of the field is not misspelled and in the intermediate window I have:

{Module_time.Ship Date} in Date (2001,01,01) to Date (2001,07,01)

Please, give me a ahnd with that...

 

[rodbac]

Hi Alira-
What error message is it returning and when? -rodbac

 

[Alira]

Run-time error #20515

Error in formula


stops at - - repC.Action = 1

 

[kenhamady]

Is this a Date field?

If you open the report in the report designer and past in your formula does it accept it there? If not it will give you a better message. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[Alira]

In report designer it would give error a ')' is missing. Apperently double quotes in format funcrion were not accepted. When I corrected it it gave me error "Not enough arguments have been given to this function" on Date function.
What I have to do?

 

[kenhamady]

Cut and paste the complete selection formula that you are testing from your report to here. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[Alira]

here it is:

{Module_time.Ship Date} in Date(" & Format(Dfrom, 'yyyy,mm,dd') & &quot to Date(" & Format(Dto, 'yyyy,mm,dd') & &quot

 

[kenhamady]

This is not a valid CR formula, this is a VB formula. I want the formula you are using while in the report designer. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[Alira]

well, I don't know how to modify it.. for designer...
Can I use Format there?Can I use variables? I don't have have Help files to answer those questions...

 

[Alira]

I tried this:
{Module_time.Ship Date} in Date (2001,01,01) to Date (2001,07,01)
telling me that string is required with cursor just before Date.

 

[kenhamady]

BINGO! That was what I was looking for.
Your Date field isn't a date, it is a string. You can't compare date values to string values in CR. You can convert the string field to a date, or if it is in a format that sorts correctly, you could give it two date strings for comparison. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[Alira]

Thanks a lot!!!
I forgot to check "Convert date\time values to date" for this report.