2 Replies Latest reply: May 15, 2014 9:58 AM by Jessica Daw RSS

    Date Extraction

    Jessica Daw

      Hello,

       

      I am trying to create a column that includes a Date value.  The given report data provides only the month and day (ie: 10/29) and I need to include the year (ie:10/29/2002).  A substring works, just by adding the "/2002" at the end, but it's a character field.  It will not let me change the field properties to a date.  Can anyone help with how to get this to a date field with the year added? 

       

      Thank you,

      Jessica Daw