hi friends i want to create a calendar dased on date field.

[#1]

HI friends  i want to create a calendar based on date field but the problem is that date field contains only yyyy-mm.

[hariprasadqv]

Hi,

Without date It might not be possible. if dates are there Master Calander concept will help you.

[#3]

hi HARI

its a actual revenue data comes from a web based application monthly , so in date field date is not available is there any way to create calendar for i have to generate only quater month and financial year from this field.

[PrashantSangle]

Hi,

USe makedate() for creating date.

makedate(YEar,Month)

Regards

[#5]

I have tried that option too

but its not working it creating problem while linking calendar and my table

[buzzy996]

use this,

[#7]

Thanks shiva but i have to create a master calendar from it.

[hariprasadqv]

Ankith try this.

LOAD Sales,

    Purchases,

    [Gross Profit],

    Overheads,

    [Operating Profit],

    [Other Expense],

    [Other Income],

    [Other Expense/Income],

    [Net Income],

    Month as date,

    YEAR(Month) as Year,

    Month(Month) as Months,

    Num(Month(Month)) as MonthNumber,

    'Q' & ceil(month(Month) / 3) as Quarter

FROM

(biff, embedded labels);

Try to load data into the QV without Null values

[jpenuliar]

add in your Script:

if(Len(Month) > 0,Date(Month&'-01','YYYY/MM/DD'),Null()) as MonthDate

[#10]

not working hari...