This content has been marked as final. Show 7 replies
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) ?