create date using quarter and year

[#1]

can we create date from year and quarter field

[vivek_niti]

Please share sample data.

[arulsettu]

try like this

makedate(year,quarter) as date

[vivek_niti]

The makedate function only accepts year, month and day as parameters.

[avinashelite]

Hi Shweta,

Build a custom calendar and like the Quarter and year ...that the easiest way to generate dates   

[#6]

how?

[#7]

Derive Month from Quarter And use makedate function with year and derived month,

If quarter = Q1, Month = Jan or Feb Or Mar Like this,

and Makedate(year, Month) As Date

Faisal

[jonathandienst]

Assuming quarter is a number between 1 and 4:

=MakeDate(year, (quarter - 1) * 3 + 1)

[#9]

pfa

[vivek_niti]

Try this code

tab1:

LOAD * INLINE [

    Year, Quarter

    2015, 1

    2015, 2

    2015, 3

    2015, 4

];

tab2:

LOAD *,

  Date(Makedate(Year,Month),'DD-MM-YYYY') AS Date;

LOAD Year,

  Quarter,

  Pick(Match(Quarter,1,2,3,4),1,4,6,10) AS Month

RESIDENT tab1;

DROP TABLE tab1;