Convert Dates to Fiscal Month and Fiscal Year
Summary
Convert Dates to Fiscal Month and Fiscal YearContent
Does anyone have a formula for Fiscal Month and Year? I need to take the Latest Filled Date and convert that to the Fiscal Month and the Fiscal Year
March 1, 2018 would convert to 12/2018
April 1, 2018 would convert to 01/2019
I could use the below but I'd like something more dynamic so I do not have to continually update this formula each year.
----------------------------------------------------------------------
case
when "Requisition Latest Filled Date"."Req. Latest Filled Month (MM)" ='01'and "Requisition Latest Filled Date"."Req. Latest Filled Year (YYYY)" = '2018' then '10/2018'
when "Requisition Latest Filled Date"."Req. Latest Filled Month (MM)" ='02'and "Requisition Latest Filled Date"."Req. Latest Filled Year (YYYY)" = '2018' then '11/2018'