1 Reply Latest reply: May 19, 2011 10:42 AM by Erich Shiino RSS

    Converting date to month year

      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