How to list all tables which was updated in last days

— Method to list all tables which was updated in current month
SELECT TABLENAME,LASTUPDATED FROM
(
SELECT B.NAME AS ‘TABLENAME’, MAX(STATS_DATE (ID,INDID)) AS LASTUPDATED,
CONVERT(VARCHAR, MAX(STATS_DATE (ID,INDID)), 103) as Date
FROM SYS.SYSINDEXES AS A
INNER JOIN SYS.OBJECTS AS B ON A.ID = B.OBJECT_ID
WHERE B.TYPE = ‘U’ AND STATS_DATE (ID,INDID) IS NOT NULL
GROUP BY B.NAME
) AS A
WHERE LASTUPDATED>=(select DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0)) AND LASTUPDATED<=(select DATEADD(ms, -3, DATEADD(mm, DATEDIFF(m, 0, GETDATE()) + 1, 0))) ORDER BY LASTUPDATED DESC -- Method to list all tables which was updated in date range SELECT TABLENAME,LASTUPDATED FROM ( SELECT B.NAME AS 'TABLENAME', MAX(STATS_DATE (ID,INDID)) AS LASTUPDATED, CONVERT(VARCHAR, MAX(STATS_DATE (ID,INDID)), 103) as Date FROM SYS.SYSINDEXES AS A INNER JOIN SYS.OBJECTS AS B ON A.ID = B.OBJECT_ID WHERE B.TYPE = 'U' AND STATS_DATE (ID,INDID) IS NOT NULL GROUP BY B.NAME ) AS A WHERE LASTUPDATED>=’2013-05-01′ AND LASTUPDATED<='2013-05-31' ORDER BY LASTUPDATED DESC