6 Replies Latest reply: Apr 30, 2015 11:56 AM by Sjoerd Stilma RSS

    date(+*value*)   Conditional

      Hi all,

       

      Ive got a relative simple question regarding changing the date in a script.

      Ive got the following LOAD statement:

       

       

      LOAD

      date(orderdate+26298) AS OrderDate,

      date(del_date+26298) AS DelDate;

       

       

      I want this statement to be conditional. In words, orderdate+26298  IF there is a value in the date field. If not then don't add this number and let it empty.

       

      In my problem it adds a value to the date even if the field is empty, so I get a date out of nothing.

       

      Any suggestions?