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:




      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?