Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gulam123
New Contributor II

How to find no of Odd saturdays between two dates

Hi Guys i just wanted to find no of Odd Saturdays between two given dates.

2 Replies
rittermd
Honored Contributor

Re: How to find no of Odd saturdays between two dates

There is a Even function that you could possible use on the day portion of the date. 

If it is Odd then the value returned by this expression is 0.

I personally have never used this.  But it seems straightforward enough.

There are also functions to determine the day of the week to pick out just Saturdays.

Hopefully that will send you down the right path.

gulam123
New Contributor II

Re: How to find no of Odd saturdays between two dates

Thanks for your response Mark

But there are possibilities that an odd Saturday(1st,3rd,5th saturday) can come on even day(even Date of month) so that logic won't work.

Any other approach would be appreciated