2 Replies Latest reply: Aug 7, 2012 8:47 AM by Stefan Wühl RSS

    In load set today date if empty

    Göran Hofstedt

      Hi

      I have a EndField that are empty if it´s still in progress. For those I want to mark with today date  today ()

      Like this: In a other table the endfield are marked with with 99999999 for the post that are still active. There I use this fomula. 

       

      Date(if(EndField2= 99999999, Today(), Date#(EndField2, 'YYYYMMDD')), 'YYYY-MM-DD') as EndField2,

       

       

      How to do it if it´s empty?

       

      If it´s to any help the table with the empty endfield all empty post are marked as 0 in i other field, named XXX34