16 Replies Latest reply: Jan 21, 2018 12:37 AM by Yeo Poh sai RSS

    I have month and year but cannot get Quarter

    Yeo Poh sai

      Hi All,


      Below script from fourm people here work fine :-


      SubField([Opportunities Expected Close Date],'-' ,3) as Year,

      Num(Month(Date#([Opportunities Expected Close Date], 'MM-DD-YYYY'))) as Month,

       

      Below from me , not working :-

          

      'Q' & ceil(Month(Date#([Opportunities Expected Close Date])),3)/3 as [quarter],


      Can some one tell me where i go wrong ?


      Paul