Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
achitreskyitgroup

date

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?

2 Replies
sunny_talwar

May be this

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

 

achitreskyitgroup
Author

It somehow gives me a blank value