Results 1 to 3 of 3

Thread: Retrieving records with null-dates

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    Join Date
    Feb 2009
    Location
    Denmark
    Posts
    335

    Default 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •