Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

MAKEDATE code not working properly

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_DATE

WHERE PSNUM2 > 1;

0 Replies