Date picker widget is almost hopeless

  1. Just to repeat Klaus’s report from June but not resolved - date format seems to be fixed at"English" - i.e. American, not English.

1a. Not a bug - feature request - could we possibly have “SQL” as.a date format for convert, etc.

  1. place a “Date field”, go into “Run” mode.
    It displays MM/DD/YYYY and a calendar icon

  2. click on the text, and start typing a date. Hmmm - should I type

Ooops - wasn’t ready to post that …

… should I type 1 2 1 8 2 0 2 5 or 1 2 / 1 8 / 2 0 2 5. - hopefully either would work, but I’ll try jst digits first.

  • type 1. shows 01
  • type 2. shows 12
  • type 1. shows 01 (can’t get beyond the MM field - digits, “/”, TAB, .,… nothing gets me beyond two digits.
  1. OK give up on typing for now. Click on the calendar icon
    Popup calendar appears - defaults to Jan1 1970. Understandable, but surely not the best default.

  2. Click on a date (01/09/1970) and then the popup disappears, and date shows properly

  3. Decide to change to the 12th. Click in between 0 and 9 in the Month field (which highlights), then type 1 2 - properly shows 01/12/19070

  4. Click on the calendar icon, select 01/03/1970

  5. Decide to change to the 12th. Click between 0 and 3 in the month field., then type 1 2

  6. The 1 changes it to 31 !! and then the 2 changes the year to 0002.

  7. Click on the calendar icon, then in the popup click on the drop-down for the year. You are presented with an array of 32 years. Choose one of them, and the calendar display changes - but the text date doesn’t. If I already had the correct month and day, and only wanted to change year, I would have expected it to happen now, without needing to click on the day again.

  8. There is also a down-arrow at top right to move forward by 32 years (32 ?? why not a multiple of 10).

  9. Click on the down-arrow to go forward - OK. But there isn’t an up-arrow to go back to earlier years. !!

  10. Actually there is - but it’s invisible. Click on the invisible up-arrow and you do go back 32 years.

  11. set the date to 02/25/2025 (use the calendar icon…)

  • click on the day section of the date text
  • use the up-arrow key to increase the date to 02/27
  • click on the calendar icon (to verify it shows up with 02/27 selected)
  • click on the icon again to remove the popup
  • hit the up-arrow key a few more times, until it shows 02/31/2025 (!??)
  • click on the calendar icon - it selects today (because 02/31/2025 is an invalid date ?)

15… Select an “ordinary” date (i.e. 2 digits in both month and day, e.g. 12/18/2025)

  • double click and hold down the mouse over the ‘day’ part
  • while keeping the mouse down, slide it to the right, to just after the ‘/’ between DD and YYYY
    it now displays 12//182025