AnsweredAssumed Answered

Calculating a Quarter of the Year from a date field

Question asked by Thewack on Feb 9, 2010
Latest reply on Dec 27, 2012 by delibebek

Title

Calculating a Quarter of the Year from a date field

Post

No Laughing...

 

Here is my calculation:

 

CloseOutQuarter =

Case ( CloseOutMonth = 1; 1; CloseOutMonth = 2;1;CloseOutMonth = 3;1;CloseOutMonth = 4;2;CloseOutMonth = 5;2;CloseOutMonth = 6;2;CloseOutMonth = 7;3;CloseOutMonth = 8;3;CloseOutMonth = 9;3;4)

 

Although it does work, I am wondering if there is a better way. One that doesn't look so "clunkity-clunk".

 

Thanks,

Jack sends 

 

FMP9, iMac OSX 

Outcomes