3 Replies Latest reply: Feb 19, 2016 5:26 PM by Chris Luscombe RSS

    Getting Date From Month and Year

    Chris Luscombe

      I have a table with Month field, Year field, and Employee Count field

       

      MonthYearEmployee Count
      Jan201410
      Feb201412
      Mar201413
      Apr201425

       

      I want to use Month and Year to determine a date so that I hook into my Master Calendar.  How do I manipulate Month and Year to end up with a new column in date format that looks like this:

       

      MonthYearDateEmployee Count
      Jan20141/1/201410
      Feb20142/1/201412
      Mar20143/1/201413
      Apr20144/1/201425

       

      Thanks!