Hi
I'm using PCC V10
I have this query that works fine, until I Query for dates greater or equal to a certain date,which I get an Expression evaluation error.
I also get the same Error when checking for values is not null.
When tried "shipdate" >= Convert('2018-12-01',SQL_DATE) I received the same error
Thanks
I'm using PCC V10
I have this query that works fine, until I Query for dates greater or equal to a certain date,which I get an Expression evaluation error.
I also get the same Error when checking for values is not null.
Code:
SELECT
Process_LOG.Process,
Process_LOG.OE,
IF(shp.Shiped is null,NUll,If(Substring(shp.Shiped, 29, 10) = '20__/__/__', null, convert(replace(Substring(shp.Shiped, 29, 10),'/','-'),SQL_DATE))) as ShipDate
FROM
SCHEDULELOG.Process_LOG
LEFT JOIN (SELECT
msk.ORD_ORDER_NO AS num,
msk.FIELD_NAME,
msk.MASK AS Shiped
FROM
CWLIVEWB.ORDE_WB_MASK AS msk
WHERE
LTrim(msk.FIELD_NAME) = 'Install') shp ON shp.num = oe
WHERE Process_LOG.Department='Shipping'
and shipdate >= '2018-12-01'
Thanks