Dynamic labels

[Anonymous]

Hi All,

My requirement is Create  dynamic labels for financial year.

Label is  As on 31^ST Apr’2016 for financial year starting. 2nd month Apr’2016 to May’2016.

I need change the lable dynamically.

As on 31^ST Apr’2016

Apr’2016 to May’2016

Apr’2016 to Jun’2016

Apr’2016 to Jul ’2016

Apr’2016 to Aug’2016

Apr’2016 to Sep’2016

Apr’2016 to Oct’2016

Apr’2016 to Nov’2016

Apr’2016 to Dec’2016

Apr’2016 to Jan’2017

Apr’2016 to Feb’2017

Apr’2016 to Mar’2017

As on 31^ST Apr’2017

[jonathandienst]

Create them from what? I suggest that you upload a sample and explain in more detail how you would like to use these labels.

[#3]

Create a variable

Let vFY='Year(Addmonths(DateField,-4))'

try this lable:

=if(month(DateField)=4,Date(monthend(DateField),'DD MMM YYYY'),'Apr '&$(vFY)&' to '& Monthname(DateField))

[Anonymous]

Hi Jona,

I need this type of Dynamic labels and calculate head count between FY Starting month to Current month.

Please help me out.

Thanks,

Krishna.