Dates formatted as dd/mm/yyyy when entered lose hours and shifts

Dates formatted as dd/mm/yyyy when entered lose hours and shifts

Posted by: peter.jenerette on 27 August 2025, 8:51 am EST

• 

  peter.jenerette

  • Post Options:
  • Link
    Copy

  Posted 27 August 2025, 8:51 am EST

  Using the attached workbook.

  1. Set windows Date/Time to (UTC+000) Dublin, Edinburgh, Lisbon, London.
  2. Load the attached workbook into SpreadJS, navigate to cell B1
  3. Enter the date either “31/3/2024” or “3/31/2024” (depends on your keyboard settings).
  4. Date will shift to previous day “30/3/2024” displayed with cell content being: “3/30/2024 11:00:00 PM” instead of displaying date as entered. This occurs for other dates, but not all dates.
     
     MyTestTEmplate.zip
• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 28 August 2025, 5:11 am EST

  Hi,

  We were able to reproduce the behavior on our end as well. At this point, we are not certain whether this is expected, so we’ve escalated it to the development team. The internal tracking ID is SJS-31238. I’ll keep you updated as soon as we receive any information.

  Regards,
  
  Priyam

• 

  peter.jenerette

  • Post Options:
  • Link
    Copy

  Posted 4 September 2025, 10:32 am EST

  How can we escalate this? Contact our account manager?