Third tuesday of every month.

[imran78]

I need to create a query that will insert record but date should be either 1st or the 3rd tuesday of each month, what code should i use.

[imran78]

or you can just give me code for third Tuesday of each month.

[imran78]

Here is a solution:


SELECT @ResultDate = DATEADD(wk, DATEDIFF(wk,0, dateadd(dd, 18 - datepart(day,getdate()),getdate()) ), 1);

this will return me Tuesday of a specific month( in this case its system date) and if i use while loop with dateadd function i can get the result.

I hope it will help others.