Collection Item Filtering Incorrectly Based on Date

[joshalo3 (Josh)]

I have a collection list that is incorrectly filtering based on date on my live site. In the designer everything shows properly but on the live site it is incorrect.

My list filters items whose “Date is less than 1 week from now”. This is based off of a date field. I limit the items to start at 1 and show 1.

For some reason it is showing next week’s item on the live site and this week’s item in the editor.

Any thoughts?

A too large to upload Licecap:

https://drive.google.com/file/d/0B_0sDqvnPho6S0g2bThfcHNfNEE/view?usp=sharing

[joshalo3 (Josh)]

Got it! needed to sort the items that were showing. Apparently because the next item was also within the parameters of the filter, I was being shown both the item whose date is tomorrow and the item whose date is a week from tomorrow.

Sorted the items from oldest to newest and my problem was resolved.

Booyau!