Visokio website     Downloads     Video tutorials     KnowledgeBase  
Date/Time: Excel import - dates parsed as numbers? - Visokio Forums
Date/Time: Excel import - dates parsed as numbers?
  •     tommyc November 30, 2012 10:50AM
    I perform an update each month with newly refreshed data set (.xlsx). I have some column headings that are dates (3/1/2010 going all the way to 9/1/2012). Most of those column headings are parsed correctly as dates, while there are others that are being parsed as numbers (41000, etc). I have checked the source to ensure the columns are formatted as DATE and have even reverted back to the previous version of Omniscope (I just updated it), and it's still happening. Any assistance would be greatly appreciated. Thanks!
  • 1 Comment
  •     tjbate November 30, 2012 11:58AM
    Tommy - Some inital things to try:

    1.) Your Data file Source import block pointing to the Excel .xlsx file has 3 different Reader options for importing from Excel - Omniscope, Excel as Text, and Excel direct
    Try using all 3 to see if they all parse the dates the same...
    2.) Try saving the Excel .xlsx file as plain vanilla .csv, and repeat the above.

    Please let us know what you observe...

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership