Forum Discussion
Custom Year column between dates
Hi, I need to create a custom Year column based on between dates Between 01/09/2014 and 31/08/2015 then 14/15 else 01/09/2015 and 31/08/2016 then 15/16 else 01/09/2016 and 31/08/2017 then 16...
Anonymous , Try a new column like
if(month([Date]) >=9 , format([Date], "YY") & "" & ((format([Date], "YY")*1)+1) ,((format([Date], "YY")*1)-1) & "" & format([Date], "YY") )
Anonymous , Try a new column like
if(month([Date]) >=9 , format([Date], "YY") & "" & ((format([Date], "YY")*1)+1) ,((format([Date], "YY")*1)-1) & "" & format([Date], "YY") )