I started simple with this shortcode, but got no results:
The problem is the query needs the post_type slug not it’s name. From the CPT plugin, we can see the slug for ‘Event’ posts is ‘events’. So this query works:
Adding the date and meta_compare also seemed to work:
Hopefully the problem was just the slug, and that’s enough to help you get the PHP code working.