Smart List "Is Empty" Condition for a Date Field Not Empty? | Community
Skip to main content
N
nhabischWings
New Participant
February 29, 2024
Solved

Smart List "Is Empty" Condition for a Date Field Not Empty?

  • February 29, 2024
  • 1 reply
  • 2331 views

Hello!
Wondering if I could get some advice on a problem: We're using a date field within a Custom Object and pulling a Smart List with the field condition of "Is Empty".

 

When our Data Integration team runs the criteria, they get around 400 Email Addresses on the data side, but within Marketo with the same criteria I only get around 90 Leads pulled.


According to them the API push for an empty field pushes a empty value on load - so my question is if for a Date field, would "Is Empty" somehow view a blank/null field as NOT empty for some reason? Is there some weirdness like the Boolean Empty = FALSE thing?

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

For the Date datatype, null and empty are identical.

1 reply

Darshil_Shah1
Darshil_Shah1
Community Manager
February 29, 2024

Your smart list i checking against all the custom records a person has associated with their record, I.e., Marketo is

pulling people who have the date field as empty in at least 1 of the custom object record, which might not be the same as how your data engineering team is pulling data.

N
nhabischWingsAuthor
New Participant
February 29, 2024

Got it, yes I am confirming that.

Was just curious if the NULL value being sent for a Date field that has no value would be causing anything that would have the "Is Empty" filter "see" a value there?

I wouldn't think so - just trying to eliminate possible sources of the discrepancy.

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
February 29, 2024

For the Date datatype, null and empty are identical.

Terms & ConditionsAccessibility statement

Loading footer...