Date search

[edmac2]

I am trying to figure out how to search a report that I have 26 field that are dates. I would like to be able to just have the records show up that are within a date range. I have done it by 1 date before, not sure how to cover all 26 dates though??

 

[dgillz]

{?DatePameter} in [{field1},{field2},.....{field26}]

should do the trick Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[HowardHammerman]

Try this:

Go into the record selection expert and click on the formula button. Open the record selection formula editor and enter something like this:

{table.date01} = Date(2002,06,01) or
{table.date02} = Date(2002,06,01) or
{table.date03} = Date(2002,06,01)

etc.

I think this is what you are getting at..

Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[edmac2]

I tried this but it does not find the last records at all that deal with the 1/2Days
{Employees.Day1} in {@StartDate} to {@EndDate} or
{Employees.Day2} in {@StartDate} to {@EndDate} or
{Employees.Day3} in {@StartDate} to {@EndDate} or
{Employees.Day4} in {@StartDate} to {@EndDate} or
{Employees.Day5} in {@StartDate} to {@EndDate} or
{Employees.Day6} in {@StartDate} to {@EndDate} or
{Employees.Day7} in {@StartDate} to {@EndDate} or
{Employees.Day8} in {@StartDate} to {@EndDate} or
{Employees.Day9} in {@StartDate} to {@EndDate} or
{Employees.Day10} in {@StartDate} to {@EndDate} or
{Employees.Week Taken1} in {@StartDate} to {@EndDate} or
{Employees.Week Taken2} in {@StartDate} to {@EndDate} or
{Employees.Week Taken3} in {@StartDate} to {@EndDate} or
{Employees.Week Taken4} in {@StartDate} to {@EndDate} or
{Employees.Week Taken5} in {@StartDate} to {@EndDate} or
{Employees.Week Taken6} in {@StartDate} to {@EndDate} or
{Employees.1/2Days1} in {@StartDate} to {@EndDate} or
{Employees.1/2Days2} in {@StartDate} to {@EndDate} or
{Employees.1/2Days3} in {@StartDate} to {@EndDate} or
{Employees.1/2Days4} in {@StartDate} to {@EndDate} or
{Employees.1/2Days5} in {@StartDate} to {@EndDate} or
{Employees.1/2Days6} in {@StartDate} to {@EndDate} or
{Employees.1/2Days7} in {@StartDate} to {@EndDate} or
{Employees.1/2Days8} in {@StartDate} to {@EndDate} or
{Employees.1/2Days9} in {@StartDate} to {@EndDate} or
{Employees.1/2Days10} in {@StartDate} to {@EndDate}

 

[HowardHammerman]

Hmm...
I wonder if you have hit a limit on the number of charcters in an expression.

Are you using datetime fields? Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269