![Megan_Rainbow Megan_Rainbow](https://community.airtable.com/legacyfs/online/avatars/3X/5/6/563b962689b07d9c5c9b1b7698be683b237a4fde.png)
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 10, 2019 01:18 PM
Hi! I’m trying to write a formula field that will read as “true” when the “end date” is either BEFORE today or ISBLANK. In other words, the label “true” should correspond to records where the end date has not yet passed or is not known.
Can someone help me with the formula for this? I’ve tried my hand at various IF statements, but can’t quite get it to work properly.
2 Replies 2
![Julian_Kirkness Julian_Kirkness](https://community.airtable.com/legacyfs/online/avatars/1X/904946bbb058ed190958034dc9e37b916e602fbd.jpg)
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 10, 2019 01:44 PM
![Megan_Rainbow Megan_Rainbow](https://community.airtable.com/legacyfs/online/avatars/3X/5/6/563b962689b07d9c5c9b1b7698be683b237a4fde.png)
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 13, 2019 11:39 AM
Thank you very much!!
![](/skins/images/FE00829FDD2AE889FAB731D8F02A8942/responsive_peak/images/icon_anonymous_message.png)