I need to select fiscal year data
I am using the following query but it is not working
SELECT * FROM TABLE WHERE STR_TO_DATE(date_column ,'%Y-%m-%d') BETWEEN CONCAT(YEAR(CURRENT_DATE)-1,'-04-01') AND CONCAT(YEAR(CURRENT_DATE),'-03-31')
Who can help!
I am working now. I want to get the current fiscal year.