5 Replies Latest reply: Nov 19, 2012 10:51 AM by Amit Kakkad RSS

    Where condition on load statement

    Marcin Sworzynski

      Hi everyone

      I'm trying to execute following statement:

       

      LOAD DATEID,WORKDAY_IN_MONTH AS WDIM,LAST_WORKDAY_IN_MONTH AS LWDIM

      RESIDENT D_DATE WHERE DATEID=date(now(),'YYYY-MM-DD 00:00:00');

       

      But table is empty. Record for today date exists in table. When I change sign = to <= table is loaded with data.