Date Range selected and resulting text box

[james]

All,

I have been using this

(

min(MonthYear))&' '&(max(MonthYear))

which works great and gives you the first month and the last month selected.

Yet, I havent bene lucky to get the month s left out, i.e if the above was "Jan 2009 May 2009", I would want the other text box to be "June 2009 Dec 2009"

Any ideas

Thanks

[johnw]

I really don't know what you're after, but maybe something like this?

date(addmonths(max(MonthYear),1),'MMM YYYY') & ' ' & max({1}MonthYear)

[james]

Im after if you have 2009 and have selecte Jan, feb, and Mar, the result would be Apr 2009 Dec 2009

[johnw]

If your data set is all the months of 2009, and you have selected January through March of 2009, and assuming I don't have a bug, my expression would return Apr 2009 Dec 2009. So one of us isn't understanding the other.

[james]

John, Just one of those days. Its golden Thanks