---
schema_version: "1"
id: 33cfbd9f4d801b963ce0381eb7f3b3da1289eba4b267e17f45a4055d7dbe79ae
title: Handle Null Dates
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_saql/guides/concept/bi-saql-functions-timezone-null-dates.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-timezone-null-dates.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: dd8bb6840134ff4ef2e1a5b5748b7dccd5e8b5bb305b497f4e111d7f899abbda
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# Handle Null Dates

Use `is not null` to filter out null dates.

```nolang
q = filter q by 'CloseDate' is not null;
q = foreach q generate 'CloseDate';
```

Projecting null values does not cause an error. For example, this Date Closed field is empty, but no error occurs.

```nolang
q = filter q by year('CloseDate') is null;
q = foreach q generate year('CloseDate') as "Date Closed";
```