Help

Reverse Quarter and Date Formula

Topic Labels: Formulas
874 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Gardner1
7 - App Architect
7 - App Architect

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’)
)

2 Replies 2

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
7 - App Architect
7 - App Architect

Perfect, thank you Ben!!