According to the advanced editor, on the OLE DB Source Output, External Columns and Output Columns, both say string[DT_STR] with a length of 70.

ScottPletcher: Sorry, i meant to say "My concern was the comparison of a varchar date with an "actual" DATE data type."

GSquared (1/7/2013)

---

paul.j.kemna (1/7/2013)

---

Wow, that makes a lot of sense. Such a simple concept that i may have overlooked in some places.

But in this case, we are assuming that I...

Wow, that makes a lot of sense. Such a simple concept that i may have overlooked in some places.

But in this case, we are assuming that I DO want...

No, I know what I SHOULD do. I am looking at previous processes and just need to know if this query would return the correct results. All of...

The actual syntax would be :

DECLARE @StartDate as date

SET @StartDate = some calculated date

DECLARE @EndDate as date

SET @EndDate = another calculated date

CONVERT([varchar](10), MyDatetimeColumn, 101) AS MyDate

...

WHERE MyDate >= @StartDate...