11 Replies Latest reply: Jun 9, 2015 5:24 AM by martha Skjellerup RSS

    Issues with importing date from excel ad formatting to monthyear

      I am importing a completion date with the following format but i want to group by on mmm-yy

      how can i convert this date field - I have tried date(completiondate,'MMM-YY) but it displays nothing - just dash "-"

      Is it better to load the dates with the month year or to format them after the load

      The purpose is to build a spreadsheet with 12 months of data per month for completion dates

      Thanks

      Rick

      Please see attachment