8
I have a table that looks like:
| Name | Start Date | End Date |
| Current Product - Set to expire | 03/29/2023 | 03/29/2024 |
| Current Product - No expiration | 03/29/2023 |
|
| Upcoming Product | 03/30/2024 |
|
I want to filter the products with a Start Date <= Today() and also have End Date >= Today(), but if there is no end date, then skip the End Date filter.
Hi @oguruma1218 ,
Try this
Share
Report
All responses (
Answers (
Filter(
SPListName,
'Start Date' <= Today() &&
(
IsBlank('End Date') ||
'End Date' >= Today()
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
