19 Replies Latest reply: Oct 26, 2015 10:53 PM by Teck Rul Saw RSS

    Getting number of days only for selected months

    Teck Rul Saw

      So the story goes like this,

       

       

       

      Initially, this "Ceil(MonthEnd(Max(Date(dateSet))) - MonthStart(Min(Date(dateSet))))" would do. It works for calculating the total number of days from August to October. However, the requirement changed, how can I get the total number of days only for the selected months? I couldn't find a way. Please help.