Selecting a max date and using it in the selection formula

[UNCTarheels]

I am reading a file and as part of the selection criteria, I need to know the maximum date in the file (TransactionDate) and use this to only to select the records that the transaction date is equal to the Maximum{(TransactionDate}).

How do I derive this date or retrieve in order to use as part of the selection criteria?

There are about 150,000 Records in the file and I only need the records that are equal to the maximum date. A little bit you, a little bit me. [hippie]

 

[synapsevampire]

Try:

Report->Edit Selection Formula->Group

{MyTable.TransactionDate} = maximum({MyTable.TransactionDate})

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com