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

Comments

  • gpigpi
    edited 4:23AM
    Do you have a records with blank date fields?
  • edited 4:23AM
    And yet make sure you call agregate function from memos on any summary band or from within its events.
    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
  • gpi wrote: »
    Do you have a records with blank date fields?

    No, I'm actually using the date field as filter in my query 'where' section.
  • Mick.pl wrote: »
    And yet make sure you call agregate function from memos on any summary band or from within its events.
    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

    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?
  • edited 4:23AM
    There are few options to do so.

    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

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.