Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello my fellow QV friends! I am having trouble understanding why the code below will not work. Any ideas? Thanks
LOAD PSSTYL AS STYLE, PSSSFX AS STYLE_SUFFIX, PSSZDS AS SIZE_DESC, If(MIN(PSNUM2)<>0,MakeDate ( LEFT(MIN(PSNUM2),4), MID(MIN(PSNUM2),5,2), RIGHT(MIN(PSNUM2),2) ),0 ) AS START_SHIP_DATEWHERE PSNUM2 > 1;
LOAD
PSSTYL AS STYLE,
PSSSFX AS STYLE_SUFFIX,
PSSZDS AS SIZE_DESC,
If(MIN(PSNUM2)<>0,MakeDate ( LEFT(MIN(PSNUM2),4),
MID(MIN(PSNUM2),5,2),
RIGHT(MIN(PSNUM2),2) ),0 ) AS START_SHIP_DATE
WHERE PSNUM2 > 1;