13 Replies Latest reply: Apr 14, 2015 3:25 AM by Jo 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.