Date format.

[#1]

Hi.

my requirement is to create master calander  and quarters from below table  i tried but if i applyed any date function it is showing blank no value iam not able to understand.. calander should be in the form of fisical year

example:

year 2013-2014---------2014-2015, Q1,Q2,Q3,Q4

if i seelect 2013 may that particular may  total expendoture should show in bar chart

kindly help

[Digvijay_Singh]

I don't see data loaded in the qvw you shared, can you verify once..

[#3]

sorry for that posting new qvd plz help me in that requirement

[settu_periasamy]

Hi,

there is no data in your attachment.

Reload the data, Save it, then post the qvw file again.

[settu_periasamy · Accepted solution]

Hi,

Try the attachment. It would be helpful.

[PrashantSangle]

Hi,

For financial year use yearname()

like yearname(datefield,0,4)

and use date(), monthyear(), year() and day()

Regards,

[#7]

thanku settu .

this is same result i except but in quarter  only one quarter  is there because

     1/1/2013 0:00

    1/1/2014 0:00

    1/1/2015 0:00

    2/1/2013 0:00

    2/1/2014 0:00

    these are in mm/dd/yyyy but u took dd/mm/yyyy  where should i change to get four quarter

[settu_periasamy]

Hi,

Try to change this..

LOAD Distinct Date(Floor(Date#(pay_yearmonth, 'M/D/YYYY hh:mm')),'D/M/YYYY') as Date;