Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 23, 2022 12:16 AM
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’)
)
Nov 23, 2022 01:29 AM
Hey @Scott_Gardner1!
This should do it:
IF(
{Your Date Field},
DATETIME_FORMAT(
{Your Date Field},
"YYYY"
)
& "/Q" &
DATETIME_FORMAT(
{Your Date Field},
"Q"
)
)
Nov 23, 2022 09:57 AM
Perfect, thank you Ben!!