Title: Shortcode: Display posts between dates (plus one day)
Last modified: June 27, 2019

---

# Shortcode: Display posts between dates (plus one day)

 *  Resolved [Sea Jay](https://wordpress.org/support/users/jcollier/)
 * (@jcollier)
 * [6 years, 10 months ago](https://wordpress.org/support/topic/shortcode-display-posts-between-dates-plus-one-day/)
 * Is it possible to display posts that are between two dates – plus one day?
 * Here’s what I am using:
 * `[pods name="event" template="Event-List-General" where="CURDATE() BETWEEN CAST(
   event_display_publicly_date.meta_value as DATE) and CAST(event_start_date_lists.
   meta_value as DATE)" orderby="event_start_date_lists.meta_value ASC"]`
 * I would like to display until one day after the start date, which is stored in`
   event_start_date_lists`.
 * Is this possible? (This would be the cat’s meow. I can do everything else I’ve
   dreamed with Pods!)

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [Jim True](https://wordpress.org/support/users/jimtrue/)
 * (@jimtrue)
 * [6 years, 10 months ago](https://wordpress.org/support/topic/shortcode-display-posts-between-dates-plus-one-day/#post-11680107)
 * [https://docs.pods.io/searching-filtering-sorting/complicated-where-sort-and-filters/using-date-based-searches/](https://docs.pods.io/searching-filtering-sorting/complicated-where-sort-and-filters/using-date-based-searches/)
 * Take a look at DATEADD (might be another function depending on your MySQL) to
   add the day

Viewing 1 replies (of 1 total)

The topic ‘Shortcode: Display posts between dates (plus one day)’ is closed to new
replies.

 * ![](https://ps.w.org/pods/assets/icon.svg?rev=3286397)
 * [Pods - Custom Content Types and Fields](https://wordpress.org/plugins/pods/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/pods/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/pods/)
 * [Active Topics](https://wordpress.org/support/plugin/pods/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/pods/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/pods/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Jim True](https://wordpress.org/support/users/jimtrue/)
 * Last activity: [6 years, 10 months ago](https://wordpress.org/support/topic/shortcode-display-posts-between-dates-plus-one-day/#post-11680107)
 * Status: resolved