10 Replies Latest reply on Jan 29, 2015 2:12 PM by James Keuning

    Date Conversion Question

    Jacob Smith

      I need to transfer date data from "YYYYMM" to two columns that are "YYYY" and "MM". The tricky part is that the single-digit months are listed as "YYYYM" and the double-digit months are "YYYYMM" (e.g. March 2014 is listed as 20143 and October 2014 is listed as 201410). Anyone able to help? Thanks!