MonthName function with Concat Issue

[erric3210]

Hi All,

The below string is generated in Text box. I've used Concat() function on MonthYear field.

I've this string: Nov 2021, Dec 2021, Jan 2022, Nov 2023
I want this output: Nov, Dec 2021, Jan 2022, Nov 2023

This is just a sample data. Actually, there are number of years.

Someone please help.

Regards,

Eric

[mpc]

Hi, 

Concat can use 3 paramaters, and the third one is the sort order.

So Concat(distinct [MonthYear], ',', [MonthYear]) should work if MonthYear is a Date type field. 

In my test app:

Concat(distinct [Date de la vente.Cal.AnnéeMois], ',', [Date de la vente.Cal.AnnéeMois])

Regards