Re: Getting Quarter to Show Correctly

1508 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Need help seeing why the Quarter is not pulling correctly.

I have the following formula trying to pull the Quarter, but it shows Q1 for all the months. Example 12 is showing Q1 when it should show Q4.


Here is a picture of the column I am pulling from and the results which you can see the 12 are not correct as they should say Q4.


4 Replies 4

Im not sure, but it’s possible that it’s because 1 is part of the number 12.

Instead of using the FIND function, try using = instead.

For example:


That’s the issue. Each month numbers in the original formula should be wrapped in quotes.

The formula could also be rewritten as:

IF({Month}, "Q" & DATETIME_FORMAT(DATETIME_PARSE({Month}, "MM"), "Q"))

^ I suspect the formula can be even simpler. If {Month} is pulling from a date field, {Quarter} could do the same:

IF({Date}, "Q" & DATETIME_FORMAT({Date}, "Q"))

^^^ Smarter solution than mine.

Thank you both and got it to work using this!