nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Definition Query- Date field Null

RickeyFight

I want features to disappear when they are 14 days older then the completed date (date field in attribute table).

The catch is that I do not always know the completed date. In this case the completed date will be NULL. When I do not know the completed date I want to use the Created date (another date field in the attribute table). This created date will always have a date in it.

Is this possible?

Find more posts tagged with

Accepted answers

All comments

RickeyFight

I have enterprise Database.

RichardFairhurst

What is your data source type? CURRENT_DATE works with File Geodatabases (I tried the SQL on my own data before posting it). It should also work for a shapefile. It would not work with a Personal Geodatabase and probably won't work with any Enterprise database (SQL Server, Oracle, etc.).

RickeyFight

I ended up using this

completed_date >=DATEADD(day,0,convert(date,GETDATE())) OR created_date >=DATEADD(day,0,convert(date,GETDATE()))

I get an error with CURRENT_DATE

RichardFairhurst

If this is a file geodatabase the expression would be:

CURRENT_DATE - COMPLETED < 14 OR (COMPLETED IS NULL AND CURRENT_DATE - CREATED < 14)

The features would disappear if they were completed 14 days before today or had no completed date and were created 14 days before today. For example, January 25, 2017 would not appear on February 8, 2017, but January 26, 2017 would appear.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.