Date overlaps to next month

jeremyflint commented 3 years ago

on https://www.gmcnetwork.com/bids, we have an entry with a "close date" of 08/31/2021, however it shows up under the September grouping.

If we change the date to 08/30/2021, it shows up under August.

Here is the code we are using:

`{exp:reefine channel="project_bids" parse="inward" theme="shop" filter:fields="project_location_state|bid_date|estimated_cost_range" filter:estimated_cost_range:sort="desc" method="ajax"} {entries} {if entry_ids=='-1'}

No matching bids found.

{/if} {exp:channel:entries entry_id="{entry_ids}" disable="categories|category_fields|member_data" dynamic="no" orderby="bid_date" sort="asc" status="not closed" paginate="no"}

{bid_date format="%m/%d/%Y"}: {title}

{paginate} <div class="paging">Page {current_page} of {total_pages} pages {pagination_links}</div>
{/paginate} {/exp:channel:entries} {/entries}

{/exp:reefine} `

Patrick64 commented 3 years ago

I'll have a look at this. Is your database and server definitely set to the same time and timezone?

jeremyflint commented 3 years ago

Confirmed that server, PHP and EE localization are all set to "America/Chicago" (GMT -5).

Here is the page where I am using reefine and you can see under September (7) that the first post listed is dated 08/31/2021 - https://www.gmcnetwork.com/bids

Patrick64 commented 3 years ago

@jeremyflint I've put in a fix, hopefully that should do it.

Patrick64 / reefine

Date overlaps to next month #6