Skip to main content

blank dates

Hi,
What would u specify to filter for data with blank dates? I presume the @isblank function work as it is for character?

ravisdxb Thu, 03/21/2019 - 00:55

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.