Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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’)
)
2 Replies 2
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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"
)
)
Reply
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 23, 2022 09:57 AM
Perfect, thank you Ben!!