SQL Question

Results 1 to 2 of 2

Thread: SQL Question

  1. #1
    Join Date
    Dec 1969

    Default SQL Question

    Hi...I have this where clause<BR><BR>Where<BR>helprequests.calltaken &#062;= @mydate-2 <BR>@mydate contains Getdate() value<BR>It returns fields with calltaken value of July 1, 2001 However, when I do<BR>Where<BR>helprequests.calltaken &#062;= @mydate-1<BR>It should also return the July 1, 2001 record but IT DOES NOT!<BR><BR>This is killing me! I have already spent 2 days and can&#039;t figure out the problem. Please help!

  2. #2
    helper Guest

    Default RE: SQL Question

    Try DateAdd() function<BR><BR>someting like DateAdd(dd, -1, @mydate)

Posting Permissions

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