Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I make an Office Connector query show records where a date field is blank?

April 26, 2017blank connector field Office query records

0

Posted

How do I make an Office Connector query show records where a date field is blank?

1 Answer

0

Posted

Date fields in queries are special in how they handle blank values; you must use the Is operator (instead of =) and the special value NULL. For example, to show a list of active employees, you want to show records where the termination date Is NULL.