Converting date to month year

[#1]

I have a list of dates which i have converted to month and year for use in selections within an application.

year(date), month(date) etc.

I was wondering if it was possible to create a combined date/month field for use in selections.

I have tried to convert it using (Date(Date, 'MMM-YY')) as MonthYear, but when creating a list box it has created a MonthYear for every date in that month.

Thanks for any help

[erichshiino · Accepted solution]

Use this:

(Date(monthstart(Date), 'MMM-YY'))

[havko]

u saved me thanks