Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

philmywallet
New Contributor III

Modified Date for SQL table

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

2 Replies
mark6505
Valued Contributor III

Re: Modified Date for SQL table

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

Employee
Employee

Re: Modified Date for SQL table

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

Community Browser