CODEWITHSUNDEEP
salesforcesoql
Kunal Deo
Kunal Deo

Reputation: 2298

Checking for Blank Date field in Salesforce

How do I check if a field is Blank in Salesforce using SOQL.

Thanks

Upvotes: 13

Views: 26234

Answers (1)

Brian Willis
Brian Willis

Reputation: 23854

SOQL has support for NULL values, so you should be able to query as you do with regular SQL. For example:

SELECT column
FROM table
WHERE date_field = NULL

Notice the use of = NULL instead of IS NULL as you would find in SQL.

Upvotes: 25

Related Questions