date & time modified

[PowerMike]

I have a database with 1600 records of client self-entered data (it's basically an electronic directory). Each record contains date entered, date modified, time entered, and time modified fields. All of this is hosted on the web with custom HTML pages and CDML tags.

I would like to be able to automatically display, on a web page, the date and time the database was last updated. Is there a way to determine when the most recent record was updated in the database and then display that date modified and time modified information from the most recently updated record?

I was thinking this might be possible with a calculation field that "somehow" finds the most recently updated record and then displays that data, but I'm not sure.

This is not an important problem, it's very low priority, but any help will be appreciated.

BTW, I just recently discovered the FMForums site. What a treasure!

[Vaughan]

Try Max(ModDate) in an unstored calculation. No need to perform a find.