topic date in QlikView

date

achitreskyitgroup — Wed, 25 Nov 2020 16:16:04 GMT

WED:
NoConcatenate
LOAD * Resident Initial_Load
WHERE RowNumber = $(Header) - 9
;

LET vWED = subfield(Peek('A', 0, 'Vendor'),':',2);
Drop table WED;

I declare a variable to pull date. But the format of the date is Jun 1, 2019. I want to convert it into 20190601. How do I do that?

sunny_talwar — Mon, 03 Jun 2019 16:20:01 GMT

May be this

LET vWED = Date(Date#(SubField(Peek('A', 0, 'Vendor'), ':', 2), 'MMM D, YYYY'), 'YYYYMMDD');

achitreskyitgroup — Mon, 03 Jun 2019 16:34:29 GMT

It somehow gives me a blank value