-
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 09:43 PM.
Reason: additional explaination
Similar Threads
-
By Simon Tonkin in forum VB Classic
Replies: 6
Last Post: 02-02-2010, 01:17 AM
-
Replies: 0
Last Post: 10-30-2002, 05:39 AM
-
By Big John in forum VB Classic
Replies: 6
Last Post: 12-19-2001, 10:31 AM
-
By Blair in forum VB Classic
Replies: 19
Last Post: 11-13-2000, 03:12 PM
-
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
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|