Selecting an emty date in Oracle Table

Tue, 02 Mar 2010 10:24:04 GMT

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

Tue, 02 Mar 2010 12:07:30 GMT

I have found the solution. I used the function

isnull("END_ACTIVE_DATE" and that worked....

topic Selecting an emty date in Oracle Table in QlikView