Returning Null values in date field

[#1]

Hi

Upon loading a table from a database, I am trying to put a where clause on the load so that it only loads records where the value in a date field reads NULL.

I have tried a range of expressions including the simplest I would anticipate working which was:

Where "ASS_DISP_DATE" = 'NULL';

with "Ass_Disp_date' being the datefield I want to apply the restriction to. However everything I try returns the following error message:

"Conversion failed when converting datetime from charcter string"

If anybody could advise me on the correct syntax that I should be using to solve this problem then it would be much appreciated.

Kind Regards,

Steve

[CELAMBARASAN · Accepted solution]

Hi,

     If you are loading from excel file then you can use this

     "ASS_DISP_DATE" = NULL();

     If you are loading it from database then use

     "ASS_DISP_DATE"  IS NULL;

Hope it helps

Celambarasan

[#3]

Hi,

    Try to convert the date field to string and then see.I think it will work then.Let me know if you need more

    help on this.

Regards

Navin.G

[#4]

What about:  Where LEN(TRIM(ASP_DISP_DATE)) < 1;