Month Expression

[#1]

Hi All,

I have a text object named as view current month. I have added in the actions tab -

1. Clear all

2. Select in field - Month(Today).

But when i click on the text object view current month. Indeed it shows the current month on the top but also it shows all the data - including previous months and years.

My requirement is when i click on the view current month, it should display only that month.

For example if iam in January month - It should show only january data.

Currently it shows Jan ,2014 on the top until back to 2008 data.

Thanks for the help here.

Ben

[MK_QSL]

Write in text box

Only(Month)

[#3]

PFA,

Hope this will help you

[#4 · Accepted solution]

Change your second action to

Select in Field - Month(Today()).

[#5]

Hello All,

Month(Today()) works. But the problem is it shows data for Feb -2014, Feb -2013, Feb .2012 .....etc

It is not just showing Feb 2014 Data.

So I added another select in field with Year (Today()). Now it show for 2014 data including january.

Any other solution

Thanks

Ben

[#6]

Panicker see my previous attached file it will help this

[MayilVahanan]

Hi

Do you have monthyear field?

if so, try with that.

or

Year ->  Max(Year) or  Year(Max(DateField))

Month -> Month(Today()) or  Month(Max(DateField))

hope it helps

[#8]

Hi All,

It works now.

Solution:

Select in field - Month(Today())

Select in field - Year(Today())

Here in the field I have taken the appropriate field name.

My issue was i have 20 tabs and this object was linked. but the month field names were different.

I have input the correct field names accordingly in each sheet and unlinked the same. so its working.

Another workaround i guess is in the script i need to make it unique for all the months and year.

Thanks

Ben