Date in 4 Quarter

[#1]

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

(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

[Sokkorn · Accepted solution]

Hi Rahul,

Try this:

Load Date, 
     Month (Date) as Month,
     Year (Date) as Year,
     'Q' & CEIL(MONTH([Date])/3)     as Quarter
FROM
(biff, embedded labels, table is Fact$);

Hope this help.

Regards,

Sokkorn