Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    8

    Unanswered: question on date function for getdate()

    Can anyone tell me how to caluculate the 15th of each month using getdate() ?

    The function will be hardcoded in a query that will run on the third Sunday of every month.

    Thanks in advance for any help.

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    select dateadd(dd,14, dateadd(mm, datediff(mm,'20000101',getdate()),'20000101'))

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •