Dynamic filtering by date is off by one day

Occasional Visitor

I have a page with two lists, and I setup dynamic filtering on list 2 to receive the date selected in list 1. Both columns are setup identically as “date” type, displaying “date only”. But for some reason I can’t figure, it cascades one day earlier than it’s supposed to over to the second list. I developed a workaround by creating a hidden column that’s one day higher and pass that to the filter, but of course workarounds are annoying. Plus it’s confusing to the user since it displays the wrong filter criteria above the list. Any ideas what’s going on? 

0 Replies