0 Replies Latest reply: Aug 16, 2013 2:54 PM by Robert Fishel RSS

    MAKEDATE code not working properly

    Robert Fishel

      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;