Modified Date for SQL table

[Anonymous]

Hi

I want to add into my script the date when and SQL table was last modified / updated.

I have done it previously for excel files using filetime( dsfsf.xls), but I am not sure how to do this for an SQL table.

Any thoughts?

Thanks

Phil

[Mark_Little]

Hi Phil,

Where do you want to pick this up from. I.e. is it when actual table was updated in SQL or when the SQL table was loaded into QlikView?

Mark

[Clever_Anjos]

It´s only possible if you have a column into your table that holds last modified date (using a trigger for example)