Announcements
No record found.
TOPIC: How to filter data by dates (e.g., TO DATE on trade agreement lines) when some are blank?
OBJECTIVE: Show lines where a date is either blank or after today, and then save in a View
TRIED: Almost everything :)
Any guidance is appreciated
Hi Michael,
Unfortunately, nothing exists out of the box. I simple treatement to flag the record you want to a stored custom field can be a simple solution.
Regards,
Mehdi
Do you need it in code or in GUI?
In UI. This is a pretty common scenario for us (i.e., a field is either blank or equal to, greater or less than some static or dynamic value, e.g., today, this month, etc.
You can add two ranges for the same field in the filter pane:
For the current day, you can use (currentDate()), or you can include the operator with (greaterThanDate()). There are a few more similar methods.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Mallesh Deshapaga 254
Laurens vd Tang 188 Super User 2026 Season 1
André Arnaud de Cal... 131 Super User 2026 Season 1
