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.
If(MIN(PSNUM2)<>0,DateSerial(Left(MIN(PSNUM2),4),Mid(MIN(PSNUM2),5,2),Right(MIN(PSNUM2),2)),0) AS START_SHIP_DATE