benj wrote:
SELECT b.OrgID, a.OrgName,eventDate, FROM tblossevent AS b, tbOrg AS
a
WHERE eventdate BETWEEN convert(varchar,getdate()-30, 106) AND
convert(varchar,getdate(), 106)
What data type is your eventdate column? You seem to be converting your
parameter date values to text. Perhaps this is the source of your
confusion.
Jamie.
--
|