ACF Date – Loop between

If I understand correctly, you would like to use two ACF date fields from the current post, and get pages within the date range. I set up a test and was able to do it like this:

[pass fields="acf_date_1, acf_date_2"]
  [loop type="post" count="15" after="{ACF_DATE_1}" before="{ACF_DATE_2}"]
    [field title] - [field date]
  [/loop]
[/pass]

Thank you very much for your answer.
I’m sorry. I was’nt much clear on my explanation.

I want to show events that are occurring. So, i need to get posts that TODAY is in the range of ACF_DATE_1 and ACF_DATE_2.
Each of these posts have ACF_DATE_1 and ACF_DATE_2 (start and end date).

I see, thank you for clarifying. I tried this, and found that [loop] was not recognizing the second date field query. I corrected this in the newest plugin update.

So, I believe you’re looking for something like this:

[loop type="page" field="data_de_inicio" value="today" compare="<=" field_2="data_de_termino" value_2="today" compare_2=">=" date_format="Ymd"]

A shorter version would be:

[loop type="page" field="data_de_inicio" value="past" field_2="data_de_termino" value_2="future" date_format="Ymd"]

The difference between these two is that value=”past” will match past dates not including today.

Thank you very much! ??
past and future works fine.
By the way, i cannot get > or <. They are being escaped as > and <
I could use another loop to find fields equal to today, but that is not much elegant…

Sure, I made another update so you can do this:

[loop .. value="past and today" ..]

I also added a check in case comparison value is escaped. This is probably due to using the Visual editor.

Wow!
Wonderful.
Thank you very much Eliot! ??

Great, I’m glad it works. It was a good chance to improve support for ACF date fields.

I used the date field comparison in a recent project, where I had to list current events (today and future) and past events (not including today) in separate sections. That’s when I added these new parameters – and that’s why “future” includes today and “past” doesn’t.

In your case, because it’s a range between two dates, it makes sense to include today in both. I hope it’s not too confusing, I updated the documentation for [loop] to describe this feature.

[loop type="curso" field="data_de_termino" value="past" date_format="Ymd" orderby="data_de_inicio" order="ASC"]
This code filters the content correctly, but the order is incorrect!

How about: orderby="field" key="data_de_inicio"..?

Sorry for that.
Thank you!

??

Hi Eliot.
I’m trying everything i can imagine to make it work, but have not been succeeded yet.
It works fine when i list previous or future events, but when i try to list events in between (where today is between or equal start and end dates) it does not work.

The following code (and similar attempts) does not work:

[loop type="curso" field="start_date" value="today" compare="<=" field_2="end_date" value_2="today" compare_2=">=" date_format="Ymd" orderby="field" key="data_de_inicio" order="ASC"]

The following code shows all events:

[loop type="curso" field="start_date" value="past and today" field_2="end_date" value_2="future" date_format="Ymd" orderby="field" key="data_de_inicio" order="ASC"]

Any idea?

If you could give me some time, I’ll set up a test to see why it’s not working as expected. I’ll let you know when I find something.

Wonderful!
Thank you very much, Eliot!

I found the problem: I recently rewrote how multiple fields are queried, and date format was only being applied to the first field. I fixed this in the newest update (2.2.4) so your code should work as expected now. Please let me know if that works.