Why the date field on Trades export files is "missing"

We include both the time and date under the Time column, using the format:

YYYY-MM-DD HH:MM:SS.0000

The issue is that in many spreadsheet applications, dates with milliseconds aren't built-in formats. So the Time column may end up being displayed with only the time value.

The date data is still there, the Time column just needs to be reformatted in the spreadsheet application to include date formatting.

Google-Sheets-datetime.png

 

If it still doesn't work: