Date discrepancy between SP list and DFFS edit form

Forums Modern DFFS Date discrepancy between SP list and DFFS edit form

Viewing 1 reply thread
  • Author
    • #36941
      Michael Sabby

      When the users enter a date in a date field in the DFFS edit form what is saved to the SP list is different. This occurred with both version and with I have 4 examples where the dates were saved as 6/30/2023 between 8:52 and 9:34 AM UTC/Pacific time zone and all 4 records wrote to SP with a date of 6/29/23 and a time of exactly 10:00 PM. I tried changing my time zone on the SP site setting to Central at the suggestion of a peer and the behavior is still occurring. Any suggestions on how to solve the issue?

    • #36951
      Alexander Bautz

      I have tested changing the time zone in the SharePoint site to another time zone than I have on my computer and this gives me the same problem as you describe. Please note that changing the timezone has a delay before it takes effect so that might be the reason you didn’t see any change.

      The reason for this issue is that SharePoint automatically “corrects” the time to use the UTC format when saving it in the database – and then formats the date to the correct time zone when showing the date in a list view or a form.

      I’ll look into it and hopefully be able to fix this in the upcoming release (hopefylly during this weekend).


Viewing 1 reply thread
  • You must be logged in to reply to this topic.