# Last Update Date

**URL:** <https://forum.inductiveautomation.com/t/last-update-date/4139>\
**Category:** Ignition\
**Created:** [March 13, 2012, 12:47pm UTC](https://forum.inductiveautomation.com/t/last-update-date/4139 "2012-03-13T12:47:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cbabb](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cbabb/32/49029_2.png) [@cbabb](https://forum.inductiveautomation.com/u/cbabb)\
**Post date:** [March 13, 2012, 12:47pm UTC](https://forum.inductiveautomation.com/t/last-update-date/4139/1 "2012-03-13T12:47:16Z")

</div>

I was looking for an easy way to display the last update date for a table in my database…

This was a quick way I found to do so…

Just a SQL query on the text property of a Label object (my DB is MS SQL Server 2008)

SELECT ‘Last Update - ’ + CONVERT(VARCHAR(12), last\_user\_update, 107) AS [Mon DD, YYYY]  
FROM sys.dm\_db\_index\_usage\_stats  
WHERE database\_id = DB\_ID( ‘’)  
AND OBJECT\_ID=OBJECT\_ID(’’)