QvdCreate time

[qlikuser222]

hi Team,

i am trying top get the create time for the QVD's. I am using below code and every time QVD create time is giving null().

Can anyone please tell me what is  wrong with the code?

set vQVD = '..\QVD\';

QVD1:
Load * Inline [
ID, Sales,State
1, 200, NYC
2, 100, NJ
3, 260, MA];

Store QVD1 into $(vQVD)QVD1.(qvd);

Let vQVDCreateDate1 = QvdCreateTime('$(vQVD)QVD1.(qvd)');  // its giving null not sure the problem.

Thanks

[Chanty4u · Accepted solution]

Try this working for me.

set vQVD='D:\Suresh';

QVD1:
Load * Inline [
ID, Sales,State
1, 200, NYC
2, 100, NJ
3, 260, MA];

Store QVD1 into [$(vQVD)QVD1.(qvd)];

Let vQVDCreateDate1 = QvdCreateTime('$(vQVD)QVD1.(qvd)');

[Brett_Bleess]

It appears the relative path you were setting may have been the issue, the Help does not show that in an example, so I am not sure if relative paths work here, just wanted to post this for future folks.

http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/FileFu...

Regards,
Brett