Facing problem with date in qlikview

[tripatirao]

Dear All,

Attached is the excel file where my month and year are in text format.

By using that fields I need to calculate Fiscal month,Fiscal Year, Calender month ,Calender year by using that values

How Can i those value to number format.

Means if I apply num(Month)  it should show value like 5 (If I select may).

Please help me.

[MindaugasBacius]

Try like this:

=date(Date#('Apr-2011', 'MMM-YYYY'))

By knowing how to convert the date into numbers you could create a calendar.

[sunny_talwar]

May be like this:

Date(MonthStart(Date#(Month, 'MMM-YYYY')), 'MMM-YYYY') as MonthYear

[tripatirao]

Dear Sunny,

Thanks for Reply.

How can I create  master calender  with financial year, month from MonthYear field.

Regards

Tripati

[sunny_talwar]

The same way you would do with a date field. Just used MonthYear field instead of date in your master calendar creation script