Reverse Quarter and Date Formula

[Scott_Gardner1]

Hello!

Is these a way to reverse this? To show 2023/Q1 instead of Q1/2023.

IF({Your Date Field},
“Q” & DATETIME_FORMAT({Your Date Field},‘Q/YYYY’)
)

[Ben_Young1]

Hey @Scott_Gardner1!
This should do it:

IF(
    {Your Date Field},
    DATETIME_FORMAT(
        {Your Date Field},
        "YYYY"
    )
    & "/Q" &
    DATETIME_FORMAT(
        {Your Date Field},
        "Q"
    )
)

[Scott_Gardner1]

Perfect, thank you Ben!!