Exlude Friday & Saturday

[#1]

Hi,

How to exclude Friday and Saturday weekday.

Suppose I have the Date from Start Date - 01/01/2013 to End Date - 31/03/2013.

Note : I want the count of day including Saturday and Sunday.

Thanks & Regards,

Amit Kumar

[#2]

Hi

weekday(date)  gives you the number of the day in the week from 0 to 6.

Just exlude 4 and 5 (friday, saturday) from your query

regards

chris

[#3]

Hi,

I want to do the same by Networkdays,

Any Idea.

Reghards,

Amit Kumar

[#4]

Hi,

I want to do the same by Networkdays,

Any Idea.

Reghards,

Amit Kumar

[#5]

Hi,

I want to do the same by Networkdays,

Any Idea.

Reghards,

Amit Kumar

[#6]

Vessel Depart	Final BL
27-01-13	31-03-13

I want only exlude friday and Saturday between these dates by any function / variable.

Regards,

Amit Kumar

[jagan]

Hi,

Arrive one flag for this in Script and use that in expression

LOAD

     DateFieldName,

     If(WeekDay(DateFieldName) = 'Fri' OR WeekDay(DateFieldName) = 'Sat', 1, 0) AS WeekEndFlag

FROM DataSource;

Now in set analysis expression use

=Count({<WeekEndFlag = {1}>} DateFieldName)

Hope this helps you.

Regards,

Jagan.

[#8]

Sorry It will not work, Because, I want to calculate no. of days between to dates Fields excluding Friday and Saturday.

For Example :

You are going for trip: U started on 01-01-2013 (Start Date) and U reached u'r destination after 5 Months i.e - 31-05-2013 (End Date). Now I want no. of days excluding Friday and Saturday between these months, because it was weekend for u.

Regards,

Amit Kumar

[#9]

Sorry It will not work, Because, I want to calculate no. of days between to dates Fields excluding Friday and Saturday.

For Example :

You are going for trip: U started on 01-01-2013 (Start Date) and U reached u'r destination after 5 Months i.e - 31-05-2013 (End Date). Now I want no. of days excluding Friday and Saturday between these months, because it was weekend for u.

Regards,

Amit Kumar

[MayilVahanan]

Hi

Try like this with Mr.Jagan Suggestion

=Count({<WeekEndFlag = {0}>} DateFieldName)

Hope it helps