Re: Retrieving records with null-dates
The funny thing is that you can have a column in a report with the expression IsNull{Order.stopdate}, and it will print TRUE or FALSE correctly. Despite this you cannot have IsNull{Order.stopdate} in a select statement.
After a lot of experiments I found out that this works when selecting records: ToText(isNull({Order.stopdate}))='TRUE'.
It runs a little slower, but that is no problem.
Last edited by Jørgen Münster; 21-Apr-2019 at 03:32 AM.
Jørgen Münster
Senior Analyst Programmer
Dialog Consult
Denmark