Event creation in DDL spreadsheet has incorrect date format

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X EE, Master
• Fix Version/s: 7.0.0 DXP FP30, 7.0.X EE, 7.0.4 CE GA5, 7.1.X, Master
• Component/s: Dynamic Data Lists, Dynamic Data Lists > Display
• Labels:
  • ee-ts
  • liferay-digital-enterprise-70-sp5
  • liferay-fixpack-de-30-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Story Points: 1.25
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/51120
• What do you think is the root cause? (if known):
  Hide

  Previous fix can be found at AUI-3112. However, this fix is causing a regression in the unit test and we are unable to determine what is the regression since we have been unable to get the tests to run locally due to internet issues. The fix has been reverted in AUI repo and portal-ce repo.

  Show

  Previous fix can be found at AUI-3112 . However, this fix is causing a regression in the unit test and we are unable to determine what is the regression since we have been unable to get the tests to run locally due to internet issues. The fix has been reverted in AUI repo and portal-ce repo.

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