blank dates

2 posts / 0 new
Log in or register to post comments
Last post
Wed, 03/20/2019 - 20:56
#1
ericardo79
Offline
Joined: 03/07/2019 - 21:58
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?

Top
Thu, 03/21/2019 - 00:55
ravisdxb
Offline
Joined: 01/13/2019 - 06:12

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.

Images: 
Top