I am trying to create Date Filter for Price Profile Lines, but we do not always fill in the End Date. I have a Start Date Filter of:
NP('DateFilter",H9)
I am trying to use a similar function to filter out Expired Values, but I want to allow values that have no End Date. This does not work:
NP("DateFilter",,H9|@@)
NP("DateFilter",,H9|"''")
<>NP("DateFilter",,H9)
Has anyone been able to do this?
Try =NP("DATEFILTER",H9,)
Where H9 is your start date
I have a separate field for Start Date. That is absolutely the formula I am using for that. I now need to filter for the Expired items. Thank you!!
Unfortunately, I don't have any fields in my database that work this way, we don't have any possibility of blank date fields.
However, if you reverse the logic, NP("DATEFILTER",,H9) will give you a result of: ..11/03/17 - this will give you everything that comes prior to and includes your date, is that the logic you need?
or, I can successfully run a report using NP("DATEFILTER",,"@@"&H9) - but as I said, I can't confirm this will catch blank values since I do not have any.