How to get specific qvds date time

[Karim_Khan]

Hi All,

     I am using below script for getting the qvd's updated time but in my path there are n-numbers of qvds are there I want some specific qvds date n time I have tried to add below code but its not working?

L

Let vQVDPath = '....\qvd';

A:

LOAD QVD_NAMES AS QVDTableName

FROM

[QVD_List.xlsx]

(ooxml, embedded labels, table is Sheet1);

For Each File in FileList(vQVDPath& '\*.qvd')

B:   

     Load

      FileName() as TableName

      ,FileTime() as FileCreateTime

      ,QvdCreateTime('$(File)') as QVDCreateTime

      ,SubField(SubField('$(File)','\',-1),'.',1) as QVDTableName

     From [$(File)] (qvd);

Next File

Regards,

KK

New to QlikView‌

[Karim_Khan]

I had missed path sorry rest is fine

[Karim_Khan]

I had missed path sorry