Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends,
Is it possible to have list of all tags MonthName in text object like below
•September 2012, July 2013, August 2013, September 2013
Thanks,
an numeric expression you have into your cloud, maybe
concat(DISTINCT MonthName, ', ',YEAR*100+MONTH)
Not sure if I understand your request properly, but maybe
=concat(DISTINCT MonthName, ', ')
Yes, exactly like it, but order by Months.
I should use dual function?
Thanks,
concat(DISTINCT MonthName, ', ',<a sort expression>)
What the expression for sort MonthName
order by MonthName?
an numeric expression you have into your cloud, maybe
concat(DISTINCT MonthName, ', ',YEAR*100+MONTH)
Nice job