so can not seem enter date or iif statement without syntax errors!
select iif ([hire_date] = <'#2000-01-01#','old gaurd') l_employees i need write iif statement checks if [hire_date] before year 2000 replace old pros, otherwise young guns.
your logical operator invalid , have not supplied iif result want show in case [expression ]evaluates false:
select iif([hire_date] <= #2000-01-01#, 'old gaurd', 'young') l_employees 