How to calculate financial year if i don't have the month end date of the month

[#1]

Hi All,

How to calculate financial year if there is no month end date available in my date field. In below post there was some expression written by qlikview community experts and they are calculating using the month end value. Can any one give some solution to find out the required value with out that.

http://community.qlik.com/forums/t/26175.aspx

Thanks and Regards,

Rikab

[wizardo]

i dont how what expressions you mean or to calculate them without the "end of month date" but

this formula will give you the "end of month date" for each MyDate

startmonth(addmonth(MyDate,1)) -1 = end of month of MyDate

[Miguel_Angel_Baeyens]

Hello Rikab,

I'd rather use function MonthEnd(), you can use it like

MonthEnd(DateField)

Hope that helps.

[#4]

Hi Wizardo!

Sorry forgot to add the link in my post. Have added it now. Please look into it and let me the possiblilities.

Thanks and Regards,

Rikab