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 ?