Converting part of a string to a date

• pabond

  SSC Rookie

  Points: 38

  More actions

  August 28, 2013 at 8:46 am

  #279196

  Hello everyone, I am very new to this forum but came across many good forum posts so I decided to join. My question is with regard to having an embedded date in a string and converting this to a date. I have a serial number like the following "GA0120100466" where the "GA" is not needed and really only the next six digits represent the date. So I can use the MID function and the LEFT function to extract "012010" without any trouble. Problem is I would like to convert this to a date so that I can calculate the age for example. So the date should be "01/20/10". Any help on this would be greatly appreciated. I also have some charting issues that I need to sort out at some point so if this is not the correct forum for inserting charts into SSRS reports let me know please.

  Paul

• sribe

  SSC-Addicted

  Points: 421

  More actions

  August 29, 2013 at 8:13 am

  #1646003

  = FORMAT(DATESERIAL(LEFT(MID("GA0120100466",7),2),LEFT(MID("GA0120100466",3),2),LEFT(MID("GA0120100466",5),2)),"MM/dd/yy")

  - Susan

• pabond

  SSC Rookie

  Points: 38

  More actions

  September 3, 2013 at 12:53 pm

  #1647126

  Susan, thank you for your help. Worked like a charm!

  Paul Bond