Filter By Dates Stored Procedure

[marcuscoker]

Hi

I was wondering if anybody could help me with this one

I have setup a stored procedure that seems to work ok, however it does not appear to be filtering the dates correctly and i am getting back nulls when i enter some dates that i know should return values

SELECT DISTINCT
dbo.TblEmisDemographics.ExtractID, dbo.TblEmisDemographics.PracticeID, dbo.TblEmisDemographics.PatientID,
dbo.TblEmisDemographics.Surname, dbo.TblEmisDemographics.Forename, dbo.TblEmisDemographics.DOB, dbo.TblEmisDemographics.Sex,
dbo.TblEmisDemographics.HouseNumber, dbo.TblEmisDemographics.HouseName, dbo.TblEmisDemographics.No_Street,
dbo.TblEmisDemographics.Village, dbo.TblEmisDemographics.Town, dbo.TblEmisDemographics.Postcode, dbo.TblEmisDemographics.NHSNumber,
dbo.TblEmisDemographics.RegisteredGP, dbo.TblEmisDemographics.UsualGp, dbo.TblEmisDemographics.RegistrationStatus,
dbo.TblEmisDemographics.DateDeath, dbo.TblEmisDemographics.CombinedID,
dbo.TblEmisDemographics.Deleted
FROM dbo.TblEmisDemographics LEFT OUTER JOIN
dbo.TblEmisImms ON dbo.TblEmisDemographics.CombinedID = dbo.TblEmisImms.CombinedID

WHERE dbo.TblEmisDemographics.PracticeID = @PracticeID and dbo.TblEmisDemographics.extractid = @extractid and (dbo.TblEmisDemographics.Deleted = 0) AND (dbo.TblEmisImms.ID IS NOT NULL) AND (dbo.TblEmisImms.Deleted = 0) AND (dbo.TblEmisDemographics.Surname Like '%'+@Surname+'%' and (DOB >= CONVERT(DATETIME, @Starting, 103) AND DOB <= CONVERT(DATETIME, @Ending, 103)))




order by dbo.TblEmisDemographics.Surname desc

 

[SQL_Hell]

Hi, Maybe the date format is wrong and its switching the dates round to UK or American format.......

I dunno where are you from??

You can test this by entering a month value of 13