try like below
Let vYear = Year(Today()-1);
Let vMonth = Month(Today()-1);
Let vDate = Date(Today()-1 ,'YYYYMMDD');
'$(vDate)' as Date_JHT,
country as Country_JHT,
count as Count_JHT
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
store JHT into urrootfolder/$(vYear)/$(vMonth)/JHT_$(vDate).qvd(qvd);
for ex: if you load the app today, Daily qvd stored into urrootfolder/2020/dec/JHT_20201214.qvd .
Hope it helps
Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.