Skip to main content

Reverse Quarter and Date Formula

  • November 23, 2022
  • 2 replies
  • 38 views
Scott_Gardner1
Forum|alt.badge.img+16

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

Scott
This topic has been closed for replies.

2 replies

Ben_Young1
Forum|alt.badge.img+22
  • Ben_Young1
  • Brainy
  • November 23, 2022

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
    Forum|alt.badge.img+16
    • Scott_Gardner1
    • Author
    • Known Participant
    • November 23, 2022

    Perfect, thank you Ben!!

    Scott
    Terms & ConditionsAccessibility statement