How to create dynamic value in WP_Query meta_query

You should be able to do what you’re trying to do. I think the issue may be that relation should not be contained in it’s own array. It should look like this:

$prodPost = new WP_Query( array(
    'post_type'         => 'product',
    'posts_per_page'    => 6,
    'paged'             => 1,
    'meta_query'        => array( array(
        'relation'  => 'AND',
        array(
            'key'       => 'product_last_date',
            'value'     => date('d-m-Y'),
            'compare'   => '>',
        ),
        array(
            'key'       => 'product_limit',
            'value'     => $limit,
            'compare'   => '>',
        ),
    ),
) );

If it’s still not working at that point I would verify your meta keys are the correct keys and $limit holds the expected value.

See Initializing Meta Query for more examples.

Related Posts:

  1. WP Query Args – Title or Meta Value
  2. Meta query with string starting like pattern
  3. how to show posts that are missing a meta_value
  4. Does tax_query really beats meta_query in all situations?
  5. Query WooCommerce orders where meta data does not exist
  6. Execute a large WP_Query with many “AND” Meta_Queries?
  7. Query all posts where meta value is empty
  8. WP_Query min and max values
  9. WP_Query using meta_query with relation OR and orderby meta_value doesn’t work
  10. querying with custom meta field with meta_query
  11. Order by two meta keys
  12. multiple meta key but get server load is very high
  13. A WP_Query that will look for posts after 2 weeks ago OR with a certain meta value
  14. Finding all results from database within 500 miles of the given latitude and longitude [closed]
  15. Use meta_query to display events by date in custom field
  16. Meta-value query
  17. Meta query field order together with post_date order causes posts without the meta field to be unordered
  18. How to show recent and upcoming birthdays using meta_query
  19. pre_get_posts filter meta_query without conflicting existing meta_query
  20. Undefined property: WP_Query::$post
  21. Programmatically set ‘meta_query’ for filter
  22. Using WP_Query and WP_Meta_Query Outside of WordPress
  23. If two first numbers exist in wp_meta_query value
  24. WP_Query meta_query >= date
  25. Extending woocommerce admin product search
  26. WP_Query on custom field and order results
  27. Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
  28. Tax query clause inside a meta query clause?
  29. Adding an array from a query string to a WP meta_query
  30. Query multiple meta values
  31. Optional Meta Query
  32. Query by multiple meta elements not seeming to work – wordpress is timing out
  33. How do I make a meta_query OR relation work? [closed]
  34. Meta_query on same meta key, with diffrenct values
  35. Can we return all category (not post) with Custom Query Filter? [closed]
  36. Extend product search with meta in WooCommerce
  37. How does one perform a sub query with different post types
  38. how to make members list directory through wordpress post custom meta key.
  39. WP_Query with meta_query dosen’t return results
  40. meta_compare not comparing whole integer
  41. Filter posts by comparing custom meta value against postdate
  42. How to provide meta_key array to wp_query?
  43. meta queries do ‘either/or’ checks
  44. How to set up hierarchical relationships without using plugins / meta query
  45. WP Query ordering on a meta field for posts with a date in the future not ordering by datetime
  46. Selecting posts with a given meta value for a meta key
  47. Meta query compare for ID’s greater than specific ID
  48. Get every post with value in meta key
  49. get_page meta query not working, maybe a bug?
  50. Is it possible to add relation between meta_query and tax_query?
  51. add_query_arg to compare and display events from a certain date
  52. Show single posts date, in a page of posts
  53. WP_Query Class custom field parameters
  54. WP_Query not returning correct result with meta_query parameter
  55. meta_query where the meta value is not the post title
  56. Order WP_Query by meta_key priority when ‘OR’ relation used for multiple meta values
  57. Query on meta values and post title
  58. Combine query in WP_User_Query()
  59. How do i create a custom post query when the meta value is an array?
  60. Custom Meta Query doesn’t work the same on two site
  61. meta_query with meta values as serialize arrays
  62. WP Query – grouping posts by same meta key, adding together values from another key
  63. Woocommerce Get Orders By Meta Value
  64. meta_query is overriding default search
  65. Multiple WP_Query args combinations according to post type
  66. WP_Query multiple value not working
  67. How to do WP_User_Query for Nested Array value Inside Nested Array field
  68. Query for current post
  69. Custom query to retrieve oldest post and retrieve others with date interval
  70. WP_User_Query Orderby Not Working
  71. Unusual high query of user meta data
  72. Very slow query generated getting meta data from posts
  73. WordPress Query optimaization for slow query
  74. How to filter on placeholder image
  75. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  76. Meta query doesn’t remove placeholder escape before query
  77. WP Query Meta Query
  78. Query custom meta value – post view and date meta
  79. What is the best way to reset a search on a meta_key / meta_value?
  80. Slow query when selecting with large meta query or post__in
  81. How can I modify standard search query to include also ACF custom fields values?
  82. Custom WP_query and integrating into theme file
  83. WP_Query – show posts where meta value and user_email match
  84. WP Meta Query at depth 2
  85. Best way to Order Post in Home without a plugin
  86. WP_Query using meta_query with LIKE doesn’t return what it should
  87. Is there any difference between below WP_Query code snippets?
  88. Return a single custom post from multiple meta queries
  89. Sorting: custom query with orderby meta_value_num THEN by title
  90. query post based on comparison
  91. Including ‘cat’ => $cat breaks meta_query
  92. meta_query compare not doing what I want it to do
  93. Query string form $_GET[‘value’] is not working as meta value in wp_query
  94. Can’t figure out query logic
  95. WP_Query orderby not working on custom post_type
  96. 294 Queries on Mainpage of WordPress
  97. How to get all post_id and meta_value using meta_key in wp_postmeta table
  98. WP Query – Show custom posts only if user contain some user meta
  99. How do I subquery with custom meta fields?
  100. Showing Counts on Comment List with Custom Query