7 Replies Latest reply: Dec 13, 2017 1:37 PM by Sunny Talwar RSS

    Be sure that we're in working day..

    omar bensalem

      Hi guys ( stalwar1 )

      Afer a loong day, I really can't think anymore

      so, I really need ur help; the question is rather simple:

       

      if I select a date; I want to go back one Month.

      the expression I'm using is:

      date( date(Today()-1)- round( MonthEnd(Today()-30)- MonthStart(Today()-30)))

       

      But, with that, going back from 12/12/2017 using this: I got 12/11/2017 which is a sunday.. How can I go back to the closest WORKING DATE (monday or friday) ?

      Thanks !