Date Value for a table

  • Thread starter Thread starter jw22
  • Start date Start date
J

jw22

What is the code to pull the Modified Date of a table within a database,
similar to FileDateTime() to look up the date of a file on a drive?
Thanks
 
Hi
FileDateTime() returns the date a file was created OR the date the file was
modified. The created date if the file has not ben modified or the modified
date if it has been modified.

Regards
Kevin
 
Sorry - I missed your point entirely. To find the date an internal table
was modified
query the system objects like so:

SELECT MSysObjects.*, Name, DateUpdate
FROM MSysObjects
WHERE (((Name)="tblIamLookingFor"));

Regards

Kevin
 
Haste makes waste. Try this instead

SELECT Name, DateUpdate
FROM MSysObjects
WHERE (((Name)="tblIamLookingFor"));
 
Back
Top