Hello Everyone,
This is not an issue but I am curious to know about this fucntionality in Powerpivot:
I am trying to import a text file to Powerpivot. It has 10 columns with 1M records. This import is done using a schema file (.ini file). In the schema file, date is defined in this format (mm/dd/yyyy). A couple of columns in the file are dates (ORDER DATE & PURCHASE DATE). Though these columns are imported successfully without any errors, a default time-stamp adds to each one of the records. This is definitely not causing me any issues in working on powerpivot nor the results, but I am curious to know why timestamps are added to DATE fields in Powerpivot. Any ideas?
