I'm looking to group entries based on a condition between two custom date fields and the current date. I'm not even sure this is possible, but this is how it would appear visually:
Happening Now
Entry 1
Entry 2
Happening in the future
Entry 3
Entry 4
Happened in the past
Entry 5
Entry 6
These entries all have two custom date fields, biddingStartDate
and biddingEndDate
. If the current date is between biddingStartDate
and biddingEndDate
, it should go under "Happening Now"; if the current date is before biddingStartDate
, it should go under "Happening in the future"; and if the current date is after biddingEndDate
, it should go under "Happened in the past".
The other large question here would be: how would the headings even be created since they're dynamic and not stored in the database?