Question: I'm trying to edit this code to be dynamic as I'm going to schedule it to run.
Normally I would input the date in the where statement as 'YYYY-MM-DD' and so to make it dynamic I changed it to DATE(). I'm not erroring out, but I'm also not pulling data. I just need help with format and my google searching isn't helping.

```
PROC SQL;
CONNECT TO Hadoop (server=disregard this top part);

CREATE TABLE raw_daily_fcast AS SELECT * FROM connection to Hadoop(
SELECT DISTINCT
    a.RUN_DATE,
    a.SCHEDSHIPDATE, 
    a.SOURCE,
    a.DEST ,
    a.ITEM,
    b.U_OPSTUDY, 
    a.QTY,
    c.case_pack_qty

FROM CSO.RECSHIP a
  LEFT JOIN CSO.UDT_ITEMPARAM b
    ON a.ITEM = b.ITEM
  LEFT JOIN SCM.DIM_PROD_PLN c
    ON a.ITEM = c.PLN_NBR

WHERE a.RUN_DATE = DATE()
    AND a.SOURCE IN ('88001', '88003', '88004', '88006', '88008', '88010', '88011', '88012', 
                     '88017', '88018', '88024', '88035', '88040', '88041', '88042', '88047')
);
DISCONNECT FROM Hadoop;
QUIT;

```

Answer: 
Try command

```
ionic cordova build android --prod --release 

```
Any one still having this issue, a big cause of this problem is PLUGINS

run `ionic cordova plugin`

And have a look at your list of plugins, and uninstall All the dodgy ones, and those you arent SURE are working by running `ionic cordova plugin rm your-plugin-name`

This is the problem 98% of the time.