fix: filtered out data having none values in date field by khushi8112 [frappe] PR#41457 [backport/v4-dev]

Backport of !2634 (merged)

---