I have a date ( yr,day,month) that I want to use this date at "WHERE" clause to filter anything >= 1/1/20
is this correct? can I use an alias date to do this?
lname as [Last Name], fname as [First Name], patient_nbr,
convert(varchar, admin_year) +'-' + right('0' + convert(varchar, admin_month), 2)
+'-'+ right('0' + convert(varchar, admin_day), 2) as [/Completion Date]
from my table
where [completion date] >= 1/1/20 ??
I get Invalid column name 'Completion Date'.