Date parameters

[Rizla]

I have a report that gives a list records from a SQL database. I am trying to put in a date parameter to select by a Create_date field but this doesnt seem to be working.

If i change the parameter to a range value it returns records but only upto the selected end date and not including.

Is this a bug within Crystal or something to do with my database?

 

[dgillz]

What is your record selection formula? Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[Rizla]

{Quotes.Create Date} = {?Date Range}

 

[dgillz]

try "in" instead of = and let me know what happens. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[Rizla]

I am still getting the same result.

 

[LMCRYER]

I've seen funky things with date range parameters. I generally try to avoid them and use two (one for start and one for end date).

If you must use the range, try using the dateadd feature to be sure to grab everything on your last date....

LMC cryerlisa@hotmail.com

select * from Management where proj_mgmt_skills <> NULL

0 records returned

 

[dgillz]

Rizla,

Did you ever get this resolved? I have never had the problems Lisa has had with date range parameters. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com