What exactly are you looking for? You can use the function that Jimmy Jen mentioned, STATS_DATE, to get the time when the statistics for the index was last updated. If by modified you mean when something was changed in the data that is indexed, then there is no automatic way of checking that. I do not think the date when an index is created is stored anywhere.