I have a year that is an int type. I want to create a begin and end date using the year with 01/01 and 12/31. How do I do this? I am using it in the where clause
X.Date between '2001-01-01' and '2001-12-31'
only I want to be able to plug in the year field.