Dates 2

[ganjass]

CR10

Hi,

i want to bring back all records for the month that is the maximum in the date range that i'm passing as a paramater. But i cant seem to get it to work, any ideas,

Thanks in advance

 

[lbass]

For your record select, use:

{table.date} = maximum({?date})

-LB

 

[ganjass]

will that bring back all the records for the last month?

 

[GJParker]

Try

DatePart ("m",{Table.Date} ) = DatePart("m",Maximum({?Date}))

This will be evaluated by crystal so could hace an impact on performance

HTH

Gary Parker
Systems Support Analyst
Manchester, England

 

[bdreed35]

You will probably want to expand Gary's a little, so that you get the correct year as well:

DatePart ("m",{Table.Date} ) = DatePart("m",Maximum({?Date}))
and
DatePart ("yyyy",{Table.Date} ) = DatePart("yyyy",Maximum({?Date}))

~Brian

 

[lbass]

Sorry, I misread your post. The other solutions posted should work, and if you have multi-year data, you would want to use Brian's.

-LB

 

[ganjass]

Cheers guys good effort!