Date Value for a table

[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

 

[KC-Mass]

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

 

[KC-Mass]

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

 

[jw22]

Thank you very much. I will give it a try.

JW22

 

[KC-Mass]

Haste makes waste. Try this instead

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

 

[jw22]

This helped a ton.
Thanks.

Haste makes waste. Try this instead

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