Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be this
LET vWED = Date(Date#(SubField(Peek('A', 0, 'Vendor'), ':', 2), 'MMM D, YYYY'), 'YYYYMMDD');
It somehow gives me a blank value