Day Of Week

Hello,

 

I want to count the number of weekends between two dates.

 

Do you have a solution for this demand ?

 

Thanks a lot

Tagged:

Best Answer

  • @TAGORTI ,

     

    See if this works for you...

     

    Create a SYS Time module by Day with the following line items:

    Date: start()

    Day Nbr of Week: WEEKDAY(Date)

    Count Saturdays: IF Day Nbr of Week <> 6 THEN 0 ELSE 1

     

    2020-10-07_13-48-55.png

     

    In another module that is not dimensionalized by Time, you have 3 line items:

    Date1: date formatted that is entered

    Date2:date formatted that is entered

    Number of Weekends:TIMESUM('SYS Time Filter - Day'.Count Saturdays, 'Date 2', 'Date 1')

     

    2020-10-07_13-51-27.png

     

    2020-10-07_13-51-37.png

     

    Hope this works for you,

     

    Rob

     

Answers