selecting date records

[smut]

Hi,

i am a new user with Crystal and really need some help please. I am using CR 8.5

What i want to do is show a count of records in a field. Although i only want the records shown for dates in which is selected in the parameter value.

To give you some idea of the functions in which i have used already &quot;<&quot; and &quot;upto&quot;.

This is the line of code i am trying to produce data for. It looks as though it should work, but doesn't:
{QCallsStatus.Status} = &quot;Open&quot; and {Calls.DateOpened} = upto {?start date}

So i want a result showing all calls open before the start date selected in the parameter.

please help

Chris

 

[dgillz]

When you say it doesn't work, what does it do? No records returned, error message, what?

Before you get too deep into that though, try this for the second partof your selction formula:

{Calls.DateOpened} in Date(01/01/50) to {?Enddate}

I picked 01/01 50 as a safe assumption you have no records older that that. Also, make sure the {?Enddate} is a date field.

Let me know if you have any questions. Software Support for Sage Mas90, Macola, Crystal Reports and Goldmine
Cell/VM: 714-348-0964

 

[smut]

Sorry i didn't really explain the problem very well.

What i meant was when i check the code it displays the box &quot;No errors found&quot;. So the code is o.k.

It displays results, but not the results i want. It seems to show a count of all records within that month.Basically all i want is a count of all records of calls that are &quot;open&quot; inwhich haven't been closed. Showing all records before the start date selected in the parameter.

Your reply: I get the idea and i didn't have any errors showing. Although the result still showed a count of all calls.

Thanks anyway. I will try and work with this formula and adapt it to my needs.

If you have any other suggestion please inform me.
Once again thankyou
Chris

 

[kenhamady]

Is this a selection formula?
What data type is the field {Calls.DateOpened} as seen by CR? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/