4 Replies Latest reply on Aug 26, 2018 3:09 AM by Arup Dey

# Need Help with Selecting specific dates

Hi I have a set of data for entire year (excluding sat-sun and holidays).

Now I want to select only these days of every month: Monday to the last Thursday of the month. (i.e 4 days - the days before the last Thursday of the month)

thanks

• ###### 1. Re: Need Help with Selecting specific dates

Create a calculation as :

[last Thusday of each month]

{fixed year([date]),month([date]) : max(if DATEPART('weekday',[date])=5 then [date] end)}

Then create a T|F field as :

[date] <= [last Thusday of each month] and [date] >= [last Thusday of each month]-3

Put this on filter shelf and choose TRUE.

1 of 1 people found this helpful
• ###### 2. Re: Need Help with Selecting specific dates

Thanks a ton Ankit! Works like a charm!

• ###### 3. Re: Need Help with Selecting specific dates

Arup,

But there is a problem with a scenario when you have holiday on last Thursday of any month. In that case you will get data of last to last week with this calculation.

May i know what is the expectation in this scenario?

Thanks,

Ankit Bansal

• ###### 4. Re: Need Help with Selecting specific dates

Yes I too thought about that.

Then we will have to take the previous working day upto Monday (say Wed upto prev Monday - so just 3 days)