[RESOLVED] Select between 2 "dates"

[GaryMazzone]

What about converting to string (varchar) and then Convert to DateTime \

CONVERT(DATETIME(CONVERT(VARCHAR(2),month) + '/' + Convert(VARCHAR(2),day) + '/' + Convert(Varchar(4),Year) )