InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 01:49:40 GMT20http://www.sqlservercentral.com/Forums/Topic853270-1292-1.aspxoption: add it to a calendar table, logging which days are paydates. Similar stuff: [url]http://jasonbrimhall.info/?p=193[/url]Mon, 25 Jan 2010 15:26:02 GMTjcrawf02http://www.sqlservercentral.com/Forums/Topic853270-1292-1.aspxThanks Michael, That did the trick. I edited your code to:select dateadd(dd,(datediff(dd,'1/1/2010',dateadd(dd,13, dateadd(qq,datediff(qq,'1/1/2010',getdate()),'1/1/2010')))/14)*14,'1/1/2010') and that worked perfectly. I don't think that I would have figured it out just using one dateadd and one datediffMon, 25 Jan 2010 14:33:46 GMTbgsxygrmnhttp://www.sqlservercentral.com/Forums/Topic853270-1292-1.aspx[quote]bgsxygrmnThanks, but that doesn't really help me at all. I think that I would have to combine two of the functions that are listed in the link. [/quote]Do not understand your:[quote]that doesn't really help me at all.[/quote]You want someone to give you the complete T-SQL statement?Remember People here help those who help themselvesPlease read the first link in my signature block for the correct procedure to post a question, paying particular attention to table definition, sample data, expected results and [b]what you have done[/b]Mon, 25 Jan 2010 14:24:52 GMTbitbucket-25253http://www.sqlservercentral.com/Forums/Topic853270-1292-1.aspx[code="sql"]declare @FirstPayDate datetimeset @FirstPayDate = '20100101'select *, FirstPayDateOfCurrentQuarter = dateadd(dd,(datediff(dd,@FirstPayDate,dateadd(dd,13, dateadd(qq,datediff(qq,@FirstPayDate,Date),@FirstPayDate)))/14)*14,@FirstPayDate)from ( select Date = convert(datetime,'20100727') union all select Date = convert(datetime,'20100827') union all select Date = convert(datetime,'20101001') ) aorder by a.Date[/code]Results:[code="plain"]Date FirstPayDateOfCurrentQuarter----------------------- ----------------------------2010-07-27 00:00:00.000 2010-07-02 00:00:00.0002010-08-27 00:00:00.000 2010-07-02 00:00:00.0002010-10-01 00:00:00.000 2010-10-08 00:00:00.000(3 row(s) affected)[/code]Mon, 25 Jan 2010 14:24:52 GMTMichael Valentine Joneshttp://www.sqlservercentral.com/Forums/Topic853270-1292-1.aspxThanks, but that doesn't really help me at all. I think that I would have to combine two of the functions that are listed in the link.Mon, 25 Jan 2010 13:39:14 GMTbgsxygrmnhttp://www.sqlservercentral.com/Forums/Topic853270-1292-1.aspxGo here I am sure you can find what you need.[url]https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx[/url]Mon, 25 Jan 2010 13:33:52 GMTbitbucket-25253http://www.sqlservercentral.com/Forums/Topic853270-1292-1.aspxCan anyone help me compute the first paydate of the current quarter? This is assuming that there's 14 day intervals for paydates and 1/1/2010 is a paydate. So say the current date is july 27th 2010. The first paydate of the quarter would be july 2nd 2010.Can anyone help?ThanksMon, 25 Jan 2010 13:20:24 GMTbgsxygrmn