Using F j, Y date format in loopers

[dannikb]

Hi, I’ve followed the thread at Layouts/Loopers: How to display posts based on an ACF date picker?. I’m doing something very similar, where I want to only show posts where the end_date is today or later.

My query string is:
post_type=programs&post_status=publish&meta_query[0][key]=type&meta_query[0][value]= class&meta_key[1]=end_date(“F j, Y”)&meta_compare[1]=>=&meta_value[1]={{dc:global:date format=“F j, Y”}}&orderby=meta_value&meta_key=start_date&order=asc&posts_per_page=-1

But it’s not returning anything. I’m guessing it’s because of the F j, Y date format, but can you confirm? If that’s the case, is there a way to make that work?

Thanks,
Danni

[tristup]

Hi Danni,

Thanks for reaching out.
You need to use the format in the Meta Value only not in the meta key. You need to mention the exact format that has been used to store the data in the specified meta key.
You can check my colleague Runel’s comment in the following thread and maintain the same in your Query String.

Layouts/Loopers: How to display posts based on an ACF date picker?

Hello @andrewamj, The query could be like this: $query = array( 'post_type' => 'casting_call', 'meta_key' => 'production_date', 'meta_value' => date('Ymd'), // change to how "production date" is stored 'meta_compare' => '>', ); Using the @Kory’s solution in the article, we get this: post_type=casting_call&meta_key=production_date&meta_value=20210524&meta_compare=%3E I went ahead and applied this to your Casting Call layout. It should be displaying the correct items …

Hope it helps.
Thanks

[dannikb]

Thanks. I changed the query to:

post_type=programs&post_status=publish&meta_query[0][key]=type&meta_query[0][value]=class&meta_key[1]=end_date&meta_compare[1]=>=&meta_value[1]={{dc:global:date format=’F j, Y’}}&orderby=meta_value&meta_key=start_date&order=asc&posts_per_page=-1

But it still doesn’t work. I’m using F j, Y format in the ACF field (both Display Format and Return Format) and for the default setting on the site. The other examples I’m seeing on the forums, etc. use Ymd, so I’m wondering if the problem is with the F j, Y format… is it stored as a string and hence the looper can’t do the date comparison? OR, am I just formatting the query string incorrectly?

[tristup]

Hi Danni,

It seems that you are not making the Meta Query argument array properly. Can you please make it and then use the http_build_query function to format it into Query String, as described in the reference threads.

Looper Query String: Featured Products

@bobbybosler, no problem…happy to help. For a little more context on how I got that result, you might find this helpful if you need to create additional complex queries in the future… First, you’ll need a PHP environment to work in. If you’re developing locally, you can just throw any of this in your child theme’s functions.php file to ultimately get some output to work with. Start by writing out a query using the standard WP_Query syntax like so: $tax_query[] = array( 'taxo…

MEC Looper Order

Hello Jen, Your WP Query is not entirely correct. If you follow the detailed explanation of @Kory on this thread (Looper Query String: Featured Products), you should be having something like this: $meta_query[] = array( 'key' => 'mec_start_date', 'value' => date('Ymd'), 'compare' => '>=', ); $tax_query[] = array( 'taxonomy' => 'mec_category', 'terms' => 'take-action', ); $query = array( 'post_type' => 'mec-events', 'tax_query' => $tax_query, 'meta_ke…

CPT and Query String sorting Problem

Hi Tobi, If it is not working we need to check it through the WordPress admin dashboard. I would request you please provide login credentials for your site in a secure note to examine it further, including: – WordPress Site URL & Login URL – WordPress Admin username/password – Specific page where you have added this Query String To create a secure note, click the key icon underneath any of your posts. [secure-note] Thanks

If that does not work, I would suggest you share the argument array and your website login credentials for your site in a secure note to examine it further, including:

– WordPress Site URL & Login URL
– WordPress Admin username/password
– Specific page where you have added this Query String.

To create a secure note, click the key icon underneath any of your posts.

Thanks

[dannikb]

I’ve read those threads before but I’m not a PHP developer … and I get to the part where it says “Then, output that somehow utilizing http_build_query(), which will format our string accordingly” and I’m stumped. I guess the “output that somehow” needs a bit more information for me.

[marc_a]

Hey Danni,

As my colleague says, we need to check on your setup properly. Please give us the following information in a Secure Note.

• WordPress Login URL
• Admin level username and password
• Specific page where you have added this Query String.

You can find the Secure Note button at the bottom of your posts.

Thank you.