# If statement - current date and expiry date

**URL:** https://forum.kirupa.com/t/if-statement-current-date-and-expiry-date/299751
**Category:** Uncategorized
**Created:** [November 10, 2009, 4:18pm UTC](https://forum.kirupa.com/t/if-statement-current-date-and-expiry-date/299751 "2009-11-10T16:18:21Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![wispas](https://avatars.discourse-cdn.com/v4/letter/w/9de0a6/32.png) [@wispas](https://forum.kirupa.com/u/wispas)
#### Post date: [November 10, 2009, 4:18pm UTC](https://forum.kirupa.com/t/if-statement-current-date-and-expiry-date/299751/1 "2009-11-10T16:18:21Z")

</div>

i have some records in a mysql with an expiry date field…

how can i check to see if it is expired based on todays date…

if it is expired i dont want the records to show…  
only show records that are not expired.

any help please…