Thanks for the reply. I couldn’t follow your sorting instructions because the field concerned was a date field. The other stuff I managed to get right but, in the end, decided that PODS was just too hard to work with. Luckily I discovered Very Simple Event Listing (VSEL) which does everything I wanted by default; order by date, hide past events etc. Yippee.
I love WPSP but a future update where it would be easier to insert custom fields would be most welcome.