13 Replies Latest reply: Apr 14, 2015 3:25 AM by Josephinet Tedesco RSS

    Crosstable & Date Formatting

    Darrell Butler

      Hi, I'm loading an excel spreadsheet that has dates as columns from left to right.


      I'm converting this to a flat table using the crosstable function. However, this just converts the dates to microsoft excel time code.


      I've done a resident load from the crosstable load,  trying to convert my date column by using a combination of date# and date.


      However the dates under the date column still remain as text which limits the usefulness of my script.


      Has anyone got any clues.


      Thanks and regards.