microsoft
Date values should be supported
- Select a column representing dates (or, possibly, times / datetimes)
- Expect to see time series representation
- Instead, get weird number I can't correlate to actual date values. is this the int value from the epoch?
If you insert some random char in the date time string (2019-09-29X00:56) for example, SandDance won't treat it as a datetime so you can hover on a data point and understand the value.
It seems that it automatically convert string dates in standard format to Unix timestamp in milliseconds.
I can see that it parsed the strings 2018-12-18 13:35:51 and December 18, 2018, 01:35:51 PM to a numeric 1545136551000.
Surprisingly, it considered my string being GMT+1 and not GMT. GMT+1 is my local time so I assume that it defaulted to it because my strings didn't provide a TZ.
So it's helpful that it parses datetimes but it would be better if it show string datetimes in the interface and on the plots rather than the epochs.
Hi guys!
You might want to try my Data Preview vscode extension. It formats dates and numbers for the grid and charts display:
https://github.com/RandomFractals/vscode-data-preview
I just need to add the same for saving formatted dates.
Also, my extension supports a lot of different input data formats and export data options:
https://github.com/RandomFractals/vscode-data-preview#supported-json-config-binary--excel-data-file-formats
More info on that data tool for vscode devs is in this dev.to post:
https://dev.to/tarasnovak/vscode-data-preview-for-devs-around-the-39mn
