Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
achitreskyitgroup
Partner - Contributor II
Partner - Contributor II

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
Partner - Contributor II
Partner - Contributor II
Author

It somehow gives me a blank value