2 Replies Latest reply: May 15, 2014 10:04 AM by intelgio _ RSS

    Problems converting a date field YYYYMMDD to MM/DD/YYYY

    intelgio _

      I have read a few posts regarding simply going to Options/Input/Date Time Translation. The EDI file has the date in YYYYMMDD format with no slashes...


      20090528 (example...)


      I have not run across this in the past so I am sure that I might be missing something obvious that might need to be done before hand because nothing changes when I look in the table window. I am looking to get the number field to convert to MM/DD/YYYY


      I have also tried Ctod function and get a null value in the calc'd field.


      Thanks in advance...