Date.FiscalYearLabel

Date.FiscalYearLabel ( pDate, pStartMonth )

DEFINE
    /// Rótulo do ano fiscal: "AA-AA" (início-fim), ou o ano com quatro dígitos quando o ano fiscal começa em janeiro.
    /// @param {DATETIME} pDate - Data.
    /// @param {INT64} pStartMonth - Mês de início do ano fiscal (1 a 12).
    /// @returns Texto, ex.: "24-25".
    FUNCTION Date.FiscalYearLabel =
        ( pDate : DATETIME VAL, pStartMonth : INT64 VAL ) =>
        VAR vDateYear = YEAR ( pDate )
        VAR vFiscalStartYear = IF ( MONTH ( pDate ) >= pStartMonth, vDateYear, vDateYear - 1 )
        RETURN
            IF (
                pStartMonth = 1,
                FORMAT ( vDateYear, "0" ),
                FORMAT ( MOD ( vFiscalStartYear, 100 ), "00" ) & "-" & FORMAT ( MOD ( vFiscalStartYear + 1, 100 ), "00" )
            )

EVALUATE
{ Date.FiscalYearLabel ( DATE ( 2024, 7, 1 ), 7 ), Date.FiscalYearLabel ( DATE ( 2025, 3, 1 ), 1 ) }  // "24-25" · "2025"

EVALUATE { Date.FiscalYearLabel ( DATE ( 2024, 7, 1 ), 7 ), Date.FiscalYearLabel ( DATE ( 2025, 3, 1 ), 1 ) }
// "24-25" · "2025"