Troubleshooting - How to select record when value is null

Problem Description:

I am trying to run a report which returns ItemInventory where LastReceived is NULL I have tried in vain to accomplish this. My question is what syntax do you use to select a blank/null date or is there a special function for this?

Solution:

You can select blank/null date by using "IS NULL" in your query.

For Example below query will returns row whose InventoryDate is blank or null:

SELECT * FROM ItemInventory where InventoryDate IS NULL

The same way you can use "IS NOT NULL" in your query.

For Example below query will returns row whose InventoryDate is not blank or null:

SELECT * FROM ItemInventory where InventoryDate IS NOT NULL