Home Forums Reporting Services Reporting Services Converting part of a string to a date RE: Converting part of a string to a date

  • 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