Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I really don't know what you're after, but maybe something like this?
date(addmonths(max(MonthYear),1),'MMM YYYY') & ' ' & max({1}MonthYear)
Im after if you have 2009 and have selecte Jan, feb, and Mar, the result would be Apr 2009 Dec 2009
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.