Newbies PowerMike Posted December 4, 2002 Newbies Share Posted December 4, 2002 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! Link to comment Share on other sites More sharing options...
Vaughan Posted December 5, 2002 Share Posted December 5, 2002 Try Max(ModDate) in an unstored calculation. No need to perform a find. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7905 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now