• Likely you need a combination of datepart (turns date into numbers) and then possibly a CAST.