Identify or Get Fiscal Month of Date Selected from Calendar

[#1]

Hi Guys,

I have a included a Calendar in my application. We are using Fiscal month here in the company, see sample below:

Fiscal Month	=	Starting Date	Ending Date
January	=	01/01/2012	28/01/2012
February	=	29/01/2012	25/02/2012
March	=	26/02/2012	31/03/2012
April	=	01/04/2012	28/04/2012
May	=	29/04/2012	26/05/2012
June	=	27/05/2012	30/06/2012
July	=	01/07/2012	28/07/2012
August	=	29/07/2012	25/08/2012
September	=	26/08/2012	29/09/2012
October	=	30/09/2012	27/10/2012
November	=	28/10/2012	24/11/2012
December	=	25/11/2012	31/12/2012

Supposed the user selected from the calendar the date 27/05/2012 I wanted to put into variable what is the corresponding fiscal month for the selected date. In this case the month should be June since the date selected fall in range for June instead of May.

I will later on use this month as condition in my Pivot table.

Hope you can help me.

Regards,

~skip

[#2]

I am attaching an example of how to use this code in dimension calculated.

I hope you will help.

A greeting.

[#3]

Hi Daniel,

Thanks for the effort, what I'm trying to achieve is with the use of Calendar Object.

Please see attached sample.

Regards,

~skip

[#4 · Accepted solution]

I am attaching the modified document to the data table is connected to the allocation of fiscal month by the Date field and amended several expressions to see some examples.

I hope they are of your help.

A greeting.

[#5]

Hi Daniel,

Thank you very much...

The vSelectedMonthFiscal formula is very helpful and would serve the my needs.

Regards,

~skip