master, master-deprecated, 3.0.x, 3.1.x
Go to DDL and add an list of any kind with a date field, giving it a name for example test.
Go to test and switch to spreadsheet view, input a date for example, Aug 1st, 2017.
Now we have couple of things wrong here:
1. If you click the cell again, you will see the date is off by one day, ie July 31st, 2017.
2. Switch to normal view of the list, you will see the date of that entry saying Content is temporarily unavailable.
3. Add an entry with a date in the normal view, and then switch back to spreadsheet view, you will see there are two different formats:
The one added in spreadsheet view: Tue Aug 01 2017 00:00:00 GMT+0800(CST)
The one added in normal view: 2017-08-01