Table chart date mismatch

Forums SPJS Charts for SharePoint Table chart date mismatch

Viewing 1 reply thread
  • Author
    • #34887
      Phil Grant

      I’ve noticed an issue with a date field, the listview shows the date as entered (left side of attached image) but the table view shows the date one day earlier and it is the same whether formatted as a date or a string.


    • #34905
      Alexander Bautz

      This is a “classic” SharePoint problem where values are stored in the DB as UTC and shifted based on the regional settings when you view them in a normal list view or form. In this chart you are showing the raw db value.

      I’m not 100% sure, but try formatting it as “date” in the chart config – it might help.


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