IE (edge). If you enter the date directly, it will be converted one day ago

Tags: #<Tag:0x00007efc607ecfd0>
#1

Please tell me the solution.

▼If you double-click the target cell and enter “date” directly, the result will be as follows.

Incorrect example

2020/01/10 → 1/9
2020/1/10 → 1/9

Desired result

2020/01/10 → 1/10
2020/1/10 → 1/10

However, typing below is normal.

01/10/2020 → 1/10
1/10/2020 → 1/10

As reference……
If you enter the following pattern directly, it will not be converted

01/10 → 01/10
1/10 → 1/10

※Input from the date picker is normal

▼Target "columns” settings

{
  data: 'due_date',
  type: 'date',
  dateFormat: 'M/D',
  correctFormat: true,
  defaultDate: '<?php echo date('Y/m/d');?>',
  // Localizing into Japanese
  datePickerConfig: {
  yearSuffix: '年',
  showMonthAfterYear: true,
  showDaysInNextAndPreviousMonths: true,
  i18n: {
    previousMonth: '前月',
    nextMonth: '次月',
    months: moment.localeData()._months,
    weekdays: moment.localeData()._weekdays,
    weekdaysShort: moment.localeData()._weekdaysShort
    }
  },
}
#2

Hey @amada717

can you load it in a demo?

ps. we may not support all the moment features.

#3

Thank you for your reply

We can’t show you a demo, but you can see something similar on the page below. (Although the settings are slightly different, such as the format …)
https://handsontable.com/docs/7.3.0/demo-date.html

2020/01/10 → 01/09/2020
2020/1/10 → 01/09/2020

2020/01/01 → 12/31/2019
2020/1/1 → 12/31/2019

ps. we may not support all the moment features.

I’ve acknowledged.I want to solve it if I can.

#4

Here’s the demo when I use your dates but got a different result

https://jsfiddle.net/rka4wbqg/

2020/01/10 → 01/10/2020
2020/1/10 → 01/10/2020

2020/01/01 → 01/10/2020
2020/1/1 → 01/10/2020

I’m using the latest version 7.3.0.

But… I’m on Mac today and cannot test it on Windows (IE / Edge), only on a virtual machine.

Can you please try my demo and share feedback?

#5

Since I also use a Mac, it is a check in a virtual environment.
Version confirmed that it was the same.( 7.3.0 .)

When I checked the demo in the virtual environment, the previous day was displayed when it was loaded.

21
スクリーンショット 2020-01-24 21.38.21.png1039×343 14.6 KB

Also, the result of direct input is as follows.

2020/01/10 → 01/09/2020
2020/1/10 → 01/09/2020

2020/01/01 → 12/31/2019
2020/1/1 → 12/31/2019

Postscript
After experimenting with dateFormat, it seems to work correctly with the following pattern.
dateFormat: 'YYYY / MM / DD
https://jsfiddle.net/pdvaL35x/

#6

I can see a similar topic here https://github.com/handsontable/handsontable/issues/4953

I will recheck your demo on Monday when I’ll be able to test it on Windows. However, the description is pretty similar.

#7

OK. Thank you.

#8

Hey @amada717

I’ve reported it as a new issue after testing on Windows


I will update you as soon as we get this done.

1 Like
#9

OK.
Thank you for the response.

#10

Hi. I wanted to make a quick update. The following issue has been checked by our QA, and they found out that the issue is no longer replicable using the latest
Edge. For more details please check https://github.com/handsontable/handsontable/issues/6662#issuecomment-1205300344

#11