After speaking directly, we found that Jamie was trying to convert longs (number of milliseconds since the epoch) to regular date fields.
In order to do this, we need to read the data in as a long, and then convert it to a date type. I used a tMap from the long to date (dont forget to set the date format in the schema to "MM/dd/yyyy"), and the transform expression for the date field is:
