No replies to this topic

[vavjeeva]

Hi guys,

i need a sql query to find out Fourth Monday, tuesday or... in a Given Date..

i have a query to find out fourth Friday of Given Date

select (28-((Datepart(weekday, DATEADD(mm, DATEDIFF(mm,0,getdate()), 0) ))%7))

For example, If the Date is Oct 2004 ,

the Result is 22

the same way i want to to find out for all other days..

thanks in advance