qbjgqbjg
asked on
concatenate to form a date
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.
X.Date between '2001-01-01' and '2001-12-31'
only I want to be able to plug in the year field.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER