Cacher is the code snippet organizer for pro developers

if [Ticket FY] >= [OC Start FY] then "Yes"
else if [Ticket FY] = ([OC Start FY] - 1) then "No 3 Prior"
else if [Ticket FY] = ([OC Start FY] - 2) then "No 3 Prior"
else if [Ticket FY] = ([OC Start FY] - 3) then "No 3 Prior"
else "No"

-- how to evaluate based on dates using #datetime

if [trn_dt] >= #datetime(2017, 7, 01, 0, 0, 0) then "2018" 
else if [trn_dt] >= #datetime(2016, 7, 01, 0, 0, 0) then "2017"
else if [trn_dt] >= #datetime(2015, 7, 01, 0, 0, 0) then "2016"
else if [trn_dt] >= #datetime(2014, 7, 01, 0, 0, 0) then "2015"
else if [trn_dt] >= #datetime(2013, 7, 01, 0, 0, 0) then "2014"
else if [trn_dt] >= #datetime(2012, 7, 01, 0, 0, 0) then "2013"
else if [trn_dt] >= #datetime(2011, 7, 01, 0, 0, 0) then "2012"
else "n/a"