4 Replies Latest reply: Aug 29, 2013 11:10 AM by Robert Fishel RSS

    DateSerial function in QlikView

    Robert Fishel

      Hello.  I am trying to re-write a SQL statement from Access into QlikView.  A portion of the Access SQL statement uses the DateSerial function.  I know that QlikView does not use this same function, so how do I get QlikView to do the same thing?  Thank you.

       

      Original code:

      If(MIN(PSNUM2)<>0,DateSerial(Left(MIN(PSNUM2),4),Mid(MIN(PSNUM2),5,2),Right(MIN(PSNUM2),2)),0) AS START_SHIP_DATE