1 Reply Latest reply: Jun 1, 2012 2:49 AM by Sokkorn Cheav RSS

    Date in 4 Quarter

      Dear Team,

       

      I am able to split my data in Month and Year on using...

       

      Load Date,

           Month (Date) as Month,

           Year (Date) as Year,

      from

      FROM

      [C:\Documents and Settings\Fact3724250950917500274.xls]

      (biff, embedded labels, table is Fact$);

       

      But plz tell me the command by which i can devide the Date or Year Columns in 4 Quarter[Q1(jan-march),Q2(april-jun),Q3(july-sep),Q4(oct-dec)] .

       

      Regards,

      Rahul

        • Re: Date in 4 Quarter
          Sokkorn Cheav

          Hi Rahul,

           

          Try this:

          Load Date, 
               Month (Date) as Month,
               Year (Date) as Year,
               'Q' & CEIL(MONTH([Date])/3)     as Quarter
          FROM
          [C:\Documents and Settings\Fact3724250950917500274.xls]
          (biff, embedded labels, table is Fact$);
          

           

          Hope this help.

           

          Regards,

          Sokkorn