how to get financial year based on date ?

Jan 17 2020 2:41 PM

i have a column which is [tenure] and its datatype is nvarchar but tenure column has date inside

i want to get financial year from the tenure date