Hi,
What would u specify to filter for data with blank dates? I presume the @isblank function work as it is for character?
ericardo79
Offline
Last seen: 4 years 6 months ago
Joined: 03/07/2019 - 21:58
When I tried, a blank date is imported as "00/00/0000", which is internally stored as "00000000". So the filter condition DATE=="00000000" works for blank dates.
You could let IDEA define the criteria by right-clicking on a blank date and then select "Display all records containing...." and see how the criteria is constructed.
@IsBlank may not work.