RecordSelectionFormula - DATES! 1

[kab555]

I've been attempting to get a recordSelectionFormula to work. So far, I've been able to get the 1st statement below to work. An accomplishment that took me a day or so. I need to add more critera to the original statment, but I haven't been able to figure out how to put the criteria together. Anybody have the solutions? I have a feeling that I need more quotes, but how many and where??

StrSelectionFormula = "{KB_CLAIM_POLICY_AMT_VIEW.TRANS_DATE} in #" & FromDate & "# to #" & ToDate & "#" _
And &quot;{CLAIM_STATUS_HISTORY.STATUS_START_DATE} < #&quot; & ToDate & &quot;#&quot; _
And &quot;{CLAIM_STATUS_HISTORY.STATUS_END_DATE} >= #&quot; & ToDate & &quot;#&quot; _
And &quot;{CLAIM_TYPE_HISTORY.TYPE_START_DATE} < #&quot; & ToDate & &quot;#&quot; _
And &quot;{CLAIM_TYPE_HISTORY.TYPE_END_DATE} >= #&quot; & ToDate & &quot;#&quot;

 

[kenhamady]

Actually, you have too many quotes. 8 to many.
Get rid of the ones on either side of the word AND in all 4 places. You and has to be part of the literal strings passed to CR. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[kab555]

What do you know!! It works...thank you, thank you, thank you. I have just purchased your &quot;Guide to using Crystal in VB&quot;. I can't wait to see it, as I have found documentation for Crystal in VB to be very breif, if it exists at all.