Table chart date mismatch

[Phil Grant]

Hi,
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.

Cheers
Phil

Attachments:

1. 

   Table-view-date-mismatch.png
   

[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.

Alexander

[Author]

Posts