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.) 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.