To Know Last Refreshed Date of Excel,CSV and Qvd's

[pra_kale]

Hi,

Before Reloading the already developed application I always required to check the last modified date of all the Qvd's, Excel files and csv used  in the application. The QVD's and excel files are not on the same path so I have to to go to each and every path and need to check the modified date. It is a painful task to check each and every file.

So is there any script which I can include in my already build application so by doing Debug with Limited load i can get in One Table All the QVD's,CSV, excel files modified date and their path..similar like in below given format.

No	Path	Modified Date
1	E:\Qlikview\Sample.qvd	09/01/2016 11.45
2	E:\Qlikview\Test.csv	12/12/2015 18.45
3	E:\Qlikview\New folder\Name.xlsx	02/01/2016 22.15

Thanks in Advance.

[HirisH_V7]

[Karim_Khan]

Hi Hirish,

   By using ur above script we are getting latest qvds date and time but suppose if I  have list of qvds in my excel sheet and I want only those qvd's date time which are present in that sheet.

Regards,

KK

[Karim_Khan]

Hi Prasad,

    Have u got the solution.