1 Reply Latest reply: Mar 2, 2010 7:07 AM by Hans Peter Hansen RSS

    Selecting an emty date in Oracle Table

      Hi

      I'm using QlikView against an Oracle database, and I'm trying to load data from a table.

      I have this code so far:

      LOAD *

       

       

       

       

      where "ROLE" = 'Project Executive'

      and "START_DATE_ACTIVE" < Today()

      and "END_DATE_ACTIVE" >= Today();

      SQL SELECT

      "PROJECT_ID",

      "ROLE",

      "END_DATE_ACTIVE",

      "START_DATE_ACTIVE",

      "FULL_NAME"

       

       

      as ProjExec

       

       

       

       

       

      FROM APPS."PA_PROJECT_PLAYERS_V";

      as part of the data load. The problem is that the "END_DATE_ACTIVE" is empty for the current Project Executives or it can be set to a future date.

      How do I make an IF statement to handle this situation?

       

      Thx

      Hans Peter