Need a formula to pull the latest date

[michpaus]

I have a database where expediting notes are logged by my users and then a date stamp is attached to them. I am trying to extract the latest date for the very last expediting note that was recorded. For example if someone put in one note yesterday and another today I want only today's note to display on the crystal report. As it is now I am showing the first note that was logged and not the latest and I am drawing a complete blank on date formulas. Any help would be appreciated.

Thanks!

 

[synapsevampire]

By the date stamp "attached", do you mean that a datetime field is populated in a table, or within the notes field?

It's always best to clarify, posting example data and expected output generally resolves this, and including your software version and database should always be the case.

Try grouping on whatever field is appropriate, and then in the Report->Selection formulas->Group palce:

{table.date} = maximum({table.date},{table.groupfield})

-k