Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use this:
(Date(monthstart(Date), 'MMM-YY'))
u saved me thanks