2 Replies Latest reply: Oct 17, 2012 7:46 AM by Stefan Wühl RSS

    Crosstable load with dates

      Hi,

       

      I am trying to load data from excel by using the crostable load function. My problem is that the dates are not pulled through as dates but as numbers, How do I make it pull through as dates?

       

      the load statement is...

       

      FORECAST:

      crosstable (Date, Units)

      LOAD

                *

      FROM

      [.\Prepped Files\Forecast\Forecast May2012.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

       

      I have attached a sample of the data I am tying to import.

       

      Thanks