Query feature if an attribute is null after 180 days of date on another attribute?

[Anonymous User]

Looking for a sample ArcPy script I can modify for my use. Any suggestions?

[RandyBurton]

You could try 'Between' and set hours = '00:00:00' and '23:59:59' (between will get both these values and all those inbetween).  Or add another day with timedelta.

dp = date_past.strftime("%Y-%m-%d")

wc = "Field IS NULL AND DateField BETWEEN DATE '{} 00:00:00' AND DATE '{} 23:59:59' ".format(dp,dp))
‍‍‍‍‍‍‍‍‍‍‍