Dates with in a date range

[#1]

Hi All,

I have to find the a set of dates if they lie between a date range or not.. I have tried the same with IF but it does not work for me.

Eg:

Lets say I have  place time as 23-Dec-13 and release time as 27-Dec-2013.25-Dec and 26-Dec (Holiday time) falls with in this date range..

I have an inline table and joined it to the table where i get the place time and release time so that IF statement can be used to check the availablity but this logic is not working..

I have used

if(place time <= Holiday Time and Holiday time >= release time ,1,0) as flag

Any suggestions to resoleve this issue are much appreciated.

Thanks

[alexandros17]

To achieve the same result you can use "networkday" function, your condition however shoup work, send me your document, i'll take a look

[#3]

Thank you for the help.. actually networkdays will return me the no of days excluding saturday and sunday as well.. but i need to exclude only sunday so i could not use that.. Thanks again for quick reply...