topic Re: Modified Date for SQL table in QlikView https://community.qlik.com/t5/QlikView/Modified-Date-for-SQL-table/m-p/964885#M644348 <HTML><HEAD></HEAD><BODY><P>Hi Phil,</P><P></P><P>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?</P><P></P><P>Mark</P></BODY></HTML> Mon, 23 Nov 2015 16:11:58 GMT Mark_Little 2015-11-23T16:11:58Z Modified Date for SQL table https://community.qlik.com/t5/QlikView/Modified-Date-for-SQL-table/m-p/964884#M644347 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to add into my script the date when and SQL table was last modified / updated.</P><P></P><P>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.</P><P></P><P>Any thoughts?</P><P></P><P></P><P>Thanks</P><P></P><P></P><P></P><P>Phil</P></BODY></HTML> Mon, 23 Nov 2015 15:08:31 GMT https://community.qlik.com/t5/QlikView/Modified-Date-for-SQL-table/m-p/964884#M644347 Anonymous 2015-11-23T15:08:31Z Re: Modified Date for SQL table https://community.qlik.com/t5/QlikView/Modified-Date-for-SQL-table/m-p/964885#M644348 <HTML><HEAD></HEAD><BODY><P>Hi Phil,</P><P></P><P>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?</P><P></P><P>Mark</P></BODY></HTML> Mon, 23 Nov 2015 16:11:58 GMT https://community.qlik.com/t5/QlikView/Modified-Date-for-SQL-table/m-p/964885#M644348 Mark_Little 2015-11-23T16:11:58Z Re: Modified Date for SQL table https://community.qlik.com/t5/QlikView/Modified-Date-for-SQL-table/m-p/964886#M644349 <HTML><HEAD></HEAD><BODY><P>It´s only possible if you have a column into your table that holds last modified date (using a trigger for example)</P></BODY></HTML> Mon, 23 Nov 2015 16:58:55 GMT https://community.qlik.com/t5/QlikView/Modified-Date-for-SQL-table/m-p/964886#M644349 Clever_Anjos 2015-11-23T16:58:55Z