Default Sort Order – ACF DateTime

Anonymous

#225869

Hi, what would be the best way to go about making the default order to be sorted by ACF DateTimes, so events are shown in date order and future dates that are closest to the present show up first? I’m aware this feature is not yet available in the plugin, but there must be a way to code this up somewhere?

I need to make it happen somehow. If you could point me in the direction of which files to look at where the default order/meta key query is run, or is there a completely different/better way to go about this? Thanks

Trevor

#225907

If the ACF field saves data in the database formatted in the correct sequence, like this:

Y-m-d H:i:s (which looks like YYYY-MM-DD HH:II:SS)

So that the largest measure (years) is first, and the smallest (seconds) is last, then it cn be sorted.

In the form, I think it would look like this (note that the key name does NOT start with an underscore _:

https://www.screencast.com/t/YJqxapMzAYA

Anonymous

#225943

This has 100% fixed the issue! Amazing. Thanks

Trevor

#225947

Thanks for letting me know. I will close this thread for now.

[Author]

Posts