reloadtime within pathname

[shahamel]

Could someone help me please?

I would like to have reloadtime() within my pathname

THis is my current script

SET

ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='€ #.##0,00;€ -#.##0,00';

SET TimeFormat='h:mm:ss';

SET DateFormat='D-M-YYYY';

SET TimestampFormat='D-M-YYYY h:mm:ss[.fff]';

SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec';

SET DayNames='ma;di;wo;do;vr;za;zo';



SET Pad = 'U:\Basis\Qlikview - Sandeep\Now()';

SET Reloadtime = Now();





TEST:

LOAD

     JAAR,

     NIVEAU

FROM

Niveautest.xlsx

(ooxml, embedded labels, table is Blad1);





STORE TEST INTO [$(Pad)-test.qvd] (qvd);

[#2]

try like this:

SET Pad = 'D:\';

LET Reloadtime = PurgeChar( utc(),':');

TEST:

LOAD * INLINE [

    wed, qwerty

    com.mytest3, 1

    com.mytest2, 50

];

STORE TEST INTO $(Pad)$(Reloadtime)test.qvd (qvd);