Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Fri, Aug 4 2023 2:28 PM	Permanent Link
Peter van Mierlo EVENTSOFT	hi for some of the records a field (PrintDateTime is filled with the DateTime Now i need a DBisamTable.filter expression to show - records where the field PrintDateTime is filled - records where the field PrintDateTime is empty Whats the best way to achieve this based on a Table.Filter option
Fri, Aug 4 2023 2:38 PM	Permanent Link
Peter van Mierlo EVENTSOFT	Sorry..I was being too difficult for a moment...was of course PrintDateTime Is Not Null and PrintDateTime Is Null
Mon, Aug 7 2023 6:32 AM	Permanent Link
Jose Eduardo Helminsky HPro Informatica	Peter van Mierlo wrote: << Sorry..I was being too difficult for a moment...was of course PrintDateTime Is Not Null and PrintDateTime Is Null >> Maybe I am missing something but what are the other logical option if field is not null and field is null ? Just remove the filter on the field and you will achive what you want. X is not null and X is null is the entire escope of records. Regards Eduardo