Load qvd by timestamp in script

[markgraham123]

Hi,

I'm working on areq. where there were 20-30 Qvd files with same name but diff. time stamp.

YYYYMMDDFIlename.Qvd

Need to select the latest Qvd for the reload.

Can anyone pls help me in loading the latest qvd dynamically.

[markgraham123]

Sunny, its working

Small editing...

Its LET vMaxDate = Date(Peek('Date'), 'YYYYMMDD');

we were using LET vMaxDate = Date(Peek('MaxDate'), 'YYYYMMDD');

where der is no 'MaxDate'.. we have only 'Date'

[sunny_talwar]

Hahahaha ya, yet again a silly mistake. But you have been on top of your game Mark.

I am glad you got it all fixed.

Best,

Sunny

[markgraham123]

Come on bro.

I'm learning many concepts from u...

Lucky that u have been der...

[narband2778]

Hi Sunny,

I got QVD's for every hour stored for last 3 months and the file name of the QVD's are like "NAME_03.10.2019 12:00.QVD".

So, everyday 24 qvd's are generated, but I want to load everyday's 12 PM and 8 PM QVD's  ( "NAME_03.10.2019 12:00.QVD" and "NAME_03.10.2019 12:00.QVD" ) of rolling last 6 weeks QVD's into One Single QVD. 

IS there any way can we dynamically do this.

Thanks in advance,

Naresh