# Dataset formula to count empty dates

**URL:** <https://community.hubspot.com/t/dataset-formula-to-count-empty-dates/54234>\
**Category:** Data Hub\
**Created:** [March 31, 2022, 10:16pm UTC](https://community.hubspot.com/t/dataset-formula-to-count-empty-dates/54234 "2022-03-31T22:16:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![SimonP1](https://avatars.discourse-cdn.com/v4/letter/s/58956e/32.png) [@SimonP1](https://community.hubspot.com/u/SimonP1)\
**Post date:** [March 31, 2022, 10:16pm UTC](https://community.hubspot.com/t/dataset-formula-to-count-empty-dates/54234/1 "2022-03-31T22:16:46Z")

</div>

Hi all,

I am using datasets and formulas and trying to figure out how to calculate the number of empty dates in a specific custom field. Is there a formula that checks whether a date field is empty and returns a true/false?

---

<div class="post-metadata">

**Author:** ![LMeert](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lmeert/32/103847_2.png) [@LMeert](https://community.hubspot.com/u/LMeert)\
**Post date:** [April 5, 2022, 2:33pm UTC](https://community.hubspot.com/t/dataset-formula-to-count-empty-dates/54234/2 "2022-04-05T14:33:36Z")

</div>

Hi @SimonP1,

The datasets currently only support row-level calculation → [cf. this article](https://community.hubspot.com/t5/9881-Operations-Hub/Presenting-to-you-Datasets/m-p/519300) and a reply from November 2021.

If I understand correctly, let’s say you have a purchase\_date property, you want a formula that returns the number of empty purchase\_date among all the rows in your dataset ?

If I understood correctly, you’d need an aggregate function to run a function over several rows and count if null or empty, so I’m afraid for now you won’t be able to make that work.  
Hope this helps ! If it does, please consider marking this as a solution 🙂

Have a good day,

Ludwig