Repeat inbox where clause for blank date field?

272
1
Jump to solution
04-03-2018 09:14 AM
BrentKinal1
Occasional Contributor III

I am trying to figure out the syntax for the Inbox query that filters on whether a date field is populated or not. The form is for insect trapping and date "removalDate" is populated only when the trap is taken down removalDate =  calculation (if(${confirmTakeDown} = 'y', once(today()), '')), at this point I would like to remove the record from the Inbox. It seems like the query clause should be removalDate = '', but this doesn't seem to work. Any thought on this would be greatly appreciated.

Tags (2)
0 Kudos
1 Solution

Accepted Solutions
JohnathanHasthorpe
Esri Regular Contributor

Hi Brent - try 

removalDate is null

View solution in original post

0 Kudos
1 Reply
JohnathanHasthorpe
Esri Regular Contributor

Hi Brent - try 

removalDate is null

0 Kudos