I want to create a flag for all items if it has been purchased in any previous fiscal year.
table looks like this
if(Fiscal_year=year(now())-1,1,0) as flag
Gabor is nearly there.
if(Fiscal_year<=year(now())-1,1,0) as flag
Needs to be less than or equal to current year -1
you are right, I was inattentive to the post
A little tailoring:
if(Fiscal_year<year(now()),1,0) as flag
Retrieving data ...