Date problem


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 1 of 1

Thread: Date problem

  1. #1
    Join Date
    Feb 2005
    Posts
    22

    Question Date problem

    hi all

    using msvs - this is my code

    SELECT dbo.Client.FirstName, dbo.Client.LastName, dbo.Client.Phone, dbo.Client.PhoneExt, dbo.Client.Date1, dbo.Call.LinkedCall, dbo.Call.CallNumber,
    dbo.Call.LogDatTim, dbo.Call.CallSubject1, dbo.Call.CallSubject2, dbo.Call.CallSubject3, dbo.Call_Event.InitiatorUser AS [SD Logger],
    dbo.Client.EMailId, dbo.Logon.Logon
    FROM dbo.Client INNER JOIN
    dbo.Call ON dbo.Client.ClientCode = dbo.Call.ClientCode INNER JOIN
    dbo.Logon ON dbo.Call.LogonCode = dbo.Logon.LogonCode LEFT OUTER JOIN
    dbo.Call_Event ON dbo.Call.CallNumber = dbo.Call_Event.CallNumber
    WHERE (dbo.Client.Date1 >= @StartDate) AND (dbo.Call.LogDatTim >= DATEADD(dd, - 7, @StartDate)) AND (dbo.Call.LogDatTim <= @StartDate) AND
    (dbo.Call_Event.EventCode = 1)
    ORDER BY dbo.Call.CallSubject1

    this is a report to test procedures - eg what calls are logged within a 7 day period of the start date for the user

    my problem is

    this calls a calendar (StartDate) from which you can choose the start date
    if I put in the 1/10/05 I only get some of the data up to the 10th October?? I can't see what's wrong - why do I not get all of October so far?

    I really want all records from the startdate keyed in??


    thanks
    Jewel
    Last edited by jewel; 10-18-2005 at 10:43 PM. Reason: additional explaination

Similar Threads

  1. Access ADO SQL Date Problem
    By Simon Tonkin in forum VB Classic
    Replies: 6
    Last Post: 02-02-2010, 01:17 AM
  2. Reliability Problem
    By elise in forum .NET
    Replies: 0
    Last Post: 10-30-2002, 05:39 AM
  3. Problem with Query using a Date
    By Big John in forum VB Classic
    Replies: 6
    Last Post: 12-19-2001, 10:31 AM
  4. date comparisons in SQL
    By Blair in forum VB Classic
    Replies: 19
    Last Post: 11-13-2000, 03:12 PM
  5. Date Problem YY Format
    By seb c in forum Database
    Replies: 2
    Last Post: 11-10-2000, 12:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center