4 Replies Latest reply: May 15, 2014 10:07 AM by Chickenman _ RSS

    Convert date to numeric

    Chickenman _

      Need to convert a column of dates to numeric and retain leading zero. For example, 07/16/2010 and 12/07/2010 become 07162010 and 12072010 respectively.

       

      Converted date field to character and created calculated field to strip '/' and converted to numeric, but results are as expected, 7162010. :confused:

       

      CM