Aggregated functions on Date fields
Hello,
Is it possible to use aggregated functions (MIN, MAX) in Date fields? I just get blanks.
Regards,
Leonardo Herrera
Is it possible to use aggregated functions (MIN, MAX) in Date fields? I just get blanks.
Regards,
Leonardo Herrera
Comments
If this is OK try to find out as Gpi suggests by testing value of your data field like
select MyData, IfNull(MyData, 'Y', 'N') as IsMyDataNull from AnyWhere
Mick
No, I'm actually using the date field as filter in my query 'where' section.
Ah, I see. I was trying to use it in my Title band. How can I put this summary as a title in my report? Do I have to resort to scripting?
One of them is to make a report double pass, and within first pass calculate all as you need and put the values into variables. And within final pass use these variables to fill memos at TitleBand.
Another is to make an extra query that will give you summary values at once without double pass report or waiting for any summary bands.
Mick