4 Replies Latest reply on Dec 27, 2012 9:32 AM by delibebek

    Calculating a Quarter of the Year from a date field

    Thewack

      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