AnsweredAssumed Answered

Conditional date of the week

Question asked by ultranix on Nov 18, 2013
Latest reply on Nov 18, 2013 by ultranix


Conditional date of the week


     I would like to have a calculation, that, depending on date entered, would calculate the 2nd Monday of the given month with a condition (explained later). (two fields - date_entered, date_calculated)

     1) So, if date_entered is 2013-11-05, it would return 2011-11-11,

     2) if the date has already passed this month's 2nd monday, then it would return 2nd monday of next month. so if date_entered is 2013-11-18, date_calculated would return 2013-12-09 (2nd monday of next month).