Day Of Week

TAGORTI

Hello,

 

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

 

Do you have a solution for this demand ?

 

Thanks a lot

rob_marshall

@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

 

 

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')

 

 

 

Hope this works for you,

 

Rob

 

anirudh

Hi,

Try this:

ROUND(('Date 2' - 'Date 1') / 7)

 

 

Regards,

Anirudh

 

 

TAGORTI

Thanks for your response.
I was asking about weekends
Regards

TAGORTI

@rob_marshall 

 

Thanks a lot.

 

It worked for me, I did some modifications. It fits my need.

 

Regards,