2 Replies Latest reply on Mar 17, 2017 10:19 AM by james.raikes

    Change String to date

    james.raikes

      Hi,

       

      I am trying to reconcile some data depending on the date but I have run into a few issues and would like some help please.

       

      For the date I the below columns but the month column is actually the year and month. I also have the added issues that our quarters do not follow the standard year quarters.

       

       

      YearQuarterMonth
      20164Q 16Dec 16
      20164Q 16Dec 16
      20164Q 16Dec 16
      20164Q 16Dec 16
      20164Q 16Dec 16

      I would like to get to a point where I can use the date in the workbook when creating line graphs but at the moment it is not recognising the date.

       

      Any suggestions?