buggy {{ collection:previous|next }} in collection with date and time enabled

[jimblue]

Bug description

The {{ collection:previous}} and {{ collection:next }} don’t return the correct entry.
It happens to collections with time and date enabled when entries have same date but different time.

How to reproduce

It's a really weird problem. My guess is a problem with collection sorting that is mixing date and title, but I'm not sure.
To make it easier to understand, I've created a reproduction repo : https://github.com/jimblue/statamic-buggy-nav

Logs

No response

Environment

Environment
Application Name: Statamic
Laravel Version: 11.35.1
PHP Version: 8.3.14
Composer Version: 2.8.4
Environment: local
Debug Mode: ENABLED
URL: statamic.test
Maintenance Mode: OFF
Timezone: UTC
Locale: en

Cache
Config: NOT CACHED
Events: NOT CACHED
Routes: NOT CACHED
Views: CACHED

Drivers
Broadcasting: log
Cache: file
Database: sqlite
Logs: stack / single
Mail: log
Queue: sync
Session: file

Statamic
Addons: 0
Sites: 1
Stache Watcher: Enabled (auto)
Static Caching: Disabled
Version: 5.42.1 PRO

Installation

Fresh statamic/statamic site via CLI

Additional details

No response

[jimblue]

Screen.Recording.2024-12-16.at.23.35.55.mov

[duncanmcclean]

Can you try sorting by the title as well?

{{ collection:previous in="blog" as="posts" limit="1" sort="date:asc|title:asc" }}

[jimblue]

Can you try sorting by the title as well?

{{ collection:previous in="blog" as="posts" limit="1" sort="date:asc|title:asc" }}

Nope, still buggy. (I've added the modification on the reproduction repo here if you want to try)

[jimblue]

Still needs more info?

[jimblue]

@duncanmcclean you've left the needs more info tag , but I don't know what I could share in addition to the example repo and the video? 🤔

[duncanmcclean]

Nothing, all good. I just forgot to remove the label. 😄

[jimblue]

oh ok no pb, thank you 😃