User Profile

Collapse

Profile Sidebar

Collapse
matthewanxa
matthewanxa
Last Activity: Jul 22 '08, 07:18 AM
Joined: Jul 22 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • matthewanxa
    replied to Help to query a date range
    in SQL Server
    Dear ck9663

    Thank you very much for this. It worked perfectly, exactly what I needed.

    I just removed the dd, as it is not needed - I just need the difference between the datediff(dateCr eated,getDate() ) = 0

    for day 3 I am using the same with = -2 and for day 5 the same with = -4

    Just to clarify, I am sending a series of reminder emails (day 1 day 3 and day 5) so I need to identify everyday...
    See more | Go to post

      Leave a comment:

    • matthewanxa
      started a topic Help to query a date range
      in SQL Server

      Help to query a date range

      Please forgive me, I am a neophyte at this :)

      I need to select all records created today

      I can't use GetDate because it looks for a specific hour minute and second so I need a range.

      ie select records created less than or equal to current date except less than 1 day ago.

      I will run this query at exactly the same time everyday so that will not vary.

      I can select the records...
      See more | Go to post
      No activity results to display
      Show More
      Working...