Dynamically build a year

I am trying to build a year that would start from 1st of July of the previous year until 30th of June of this year for marketing purposes. Statically it is built correctly, given a new column for the...