3 Replies Latest reply: May 5, 2015 7:32 AM by Joanna Seldon RSS

    End of Week & End of month

    Joanna Seldon

      Hiya

       

      using ....

       

      let vstart='20050101';

      let vend=date(Today(), 'YYYYMMDD');

       

      i wish to call a stat for End of week and End of Month

       

      this below gives me 7 days

       

      if(([OrderCompleteTargetDate]-'$(vend)') <= (7*24), 1,0) as  [7 Day Warning],

       

      how would I amend above to give me [end of week warning] ('Sunday') and [end of 'current' month warning] (current month from today will be end of May 2015)

       

      Please help

       

      Kind Regards

       

      joeybird