retracted

[#1]

retracted

[nirav_bhimani]

Hi,

Please explain in detail.

Regards,

Nirav Bhimani

[er_mohit]

hiiii. , DATE is my field like this 28-9-2008 to 21-9-2012.

so,

you can try this in script here

1stly you load your table then do this.

load *,

separate day:

day(DATE) AS Day,

separate month:

Month(DATE)AS Month,

for finanacial:

yeARNAME(DATE,0,2) as FinancialYear,

for quarter:

'Q' & Ceil(Month(DATE)/3) as Quarter,

          Dual(Year(DATE) & '-Q' & Ceil(Month(DATE)/3), Year(DATE) & Ceil(Month(DATE)/3)) as YearQtr,

for annual load :

year(DATE) as Year;

hope it helps you