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

    End of Week & End of month

    Joanna Seldon



      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