Support Board
Date/Time: Wed, 29 Oct 2025 07:15:45 +0000
Post From: Date format and importing data
| [2017-09-17 07:42:34] |
| User521791 - Posts: 12 |
|
Hello, I'm trying to import data from a text file. The fields format is as follows: "Date","Time","Price","Volume" 20/03/2017,23:00:00.418,2374.25,2 The import goes thru but the dates are incorrect, I'm assuming Sierra was expecting to see 03/20/2017 instead of the above. Is there a way to fix this inside Sierra? The file is a single ES contract, size 757 Mb, Excel shows an error msg there are too many records. |