Selecting the most current date

[PJMoore17]

I am creating a report that pulls from a table with multiple entries. I would like to select only the most current date for the report.

Any help would be appreciated.

 

[lbass]

The most current date per some group?

-LB

 

[PJMoore17]

My report contains 3 tables there is no grouping - I am selecting from a payhistory table that contains multiple values of a check date - ph_information.check_date(DateTime) - I want to only select the data from this table that contains the most current date in the field.

 

[lbass]

Create a SQL expression {%maxdate}:

(
select max(`check_date`)
from ph_information
)

Then in the record selection formula use:

{ph_information.check_date} = {%maxdate}

-LB