Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Reverse Quarter and Date Formula

Topic Labels: Formulas
246 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Perfect, thank you Ben!!