How pick up last day of financial year

[#1]

hi all

have financial year i want Pick it last Day that financial year 

my year Starts on 1july to 30 jun

so  i want pick last Day of that Year For Comparison with other Date

like for Year 2009-2010   30 june 2010 will be my last day for  that Financial Year

how to pick that Specific date in every financial Year

[sundarakumar]

Better create variables for the dates, then use it where ever you want

-

Sundar

[#3]

hi Sundarakumar Kalaimani   

Thanks For Reply

Can u explain with a example ?

[MK_QSL]

Something like below...

=MonthEnd(MakeDate(Right(FinanceYear,4),vFiscalMonth-1))

Where vFiscalMonth = the variable we used to calculate Fiscal Month...

Hope this help.

[#5]

Can U explain in Follwing QVW

i have tried

[MK_QSL]

=MonthEnd(MakeDate(Right(FinanceYear,4),vFM-1))

[#7]

hi manish

thanks for reply

i have tried but it's not working

[MK_QSL · Accepted solution]

FYear	=MonthEnd(MakeDate(Right(FYear,4),vFM-1))
2010/2011	30-06-11
2011/2012	30-06-12
2012/2013	30-06-13
2013/2014	30-06-14

Use as per above...

or use below in Text Object.

=MonthEnd(MakeDate(Right(Max(FYear),4),vFM-1))