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.
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?
It´s only possible if you have a column into your table that holds last modified date (using a trigger for example)
Retrieving data ...