# Provide null value to Notion's end date range?

**URL:** <https://community.n8n.io/t/provide-null-value-to-notions-end-date-range/30741>\
**Category:** Questions\
**Tags:** notion\
**Created:** [September 21, 2023, 10:00am UTC](https://community.n8n.io/t/provide-null-value-to-notions-end-date-range/30741 "2023-09-21T10:00:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tony\_McHugh](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/tony_mchugh/32/18229_2.png) [@Tony\_McHugh](https://community.n8n.io/u/Tony_McHugh)\
**Post date:** [September 21, 2023, 10:00am UTC](https://community.n8n.io/t/provide-null-value-to-notions-end-date-range/30741/1 "2023-09-21T10:00:02Z")

</div>

Hi,

Shouldn’t it be possible to provide ‘null’ as an expression to `Date End` in the Notion node to effectively make the `Range` toggle dynamic? It would save the hassle of having two separate nodes for dates with ranges and dates without…

 ![Screenshot 2023-09-21 at 11.40.57](https://europe1.discourse-cdn.com/n8n/original/3X/a/5/a59e7d31704c76f23e184204df7109a33f05d782.jpeg)

Where it says null in `{{ $json.end || null }}` I’ve also tried “” and {}.

Any insight appreciated, cheers

---

<div class="post-metadata">

**Author:** ![EmeraldHerald](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/emeraldherald/32/35355_2.png) [@EmeraldHerald](https://community.n8n.io/u/EmeraldHerald)\
**Post date:** [September 21, 2023, 4:09pm UTC](https://community.n8n.io/t/provide-null-value-to-notions-end-date-range/30741/3 "2023-09-21T16:09:38Z")

</div>

Hi @Tony_McHugh 👋

I had a quick test of this - a Date can be null, but it looks only like this occurs if the date is left blank. “Completed” is a date in this particular test database, and I could only get a `null` field out of a blank property:

 ![image](https://europe1.discourse-cdn.com/n8n/original/3X/a/a/aadc5e2fe8dd23343d459a48475fa14c90f6cb6a.jpeg)

@Jon might be able to help me confirm if this is expected (and just a rather unhelpful error message you’re getting in return) or a bug, tomorrow 🤔

Can you also let us know:

- **n8n version:**
- **Database (default: SQLite):**
- **n8n EXECUTIONS\_PROCESS setting (default: own, main):**
- **Running n8n via (Docker, npm, n8n cloud, desktop app):**
- **Operating system:**

---

<div class="post-metadata">

**Author:** ![Tony\_McHugh](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/tony_mchugh/32/18229_2.png) [@Tony\_McHugh](https://community.n8n.io/u/Tony_McHugh)\
**Post date:** [September 21, 2023, 4:17pm UTC](https://community.n8n.io/t/provide-null-value-to-notions-end-date-range/30741/4 "2023-09-21T16:17:59Z")

</div>

Hi @EmeraldHerald,

Thanks for getting back. I’ve noticed that too however I get an error when `Range` is toggled on and `Date End` is blank. Out of interest, would you mind testing that?

- **n8n version: 1.5.1**
- **Database (default: SQLite): PostgreSQL I think**
- **n8n EXECUTIONS\_PROCESS setting (default: own, main): 🤷‍♂️**
- **Running n8n via: Docker**
- **Operating system: Ubuntu-22.04**

Is there a way to save this signature by the way??

Thanks

---

<div class="post-metadata">

**Author:** ![EmeraldHerald](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/emeraldherald/32/35355_2.png) [@EmeraldHerald](https://community.n8n.io/u/EmeraldHerald)\
**Post date:** [September 22, 2023, 9:09am UTC](https://community.n8n.io/t/provide-null-value-to-notions-end-date-range/30741/5 "2023-09-22T09:09:53Z")

</div>

Hi @Tony_McHugh 👋 After both @Jon and I looked into this one a little deeper, it looks like this is probably a bug in the Notion node with how we set the range. I’ll flag this with our engineers to take a look 👍 Unfortunately I wouldn’t have any workaround for this when it comes to a Range, even after testing 😕

I don’t believe you’d be able to save that as a signature, but that should be part of the template whenever you create a new topic 👍

---

<div class="post-metadata">

**Author:** ![Tony\_McHugh](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/tony_mchugh/32/18229_2.png) [@Tony\_McHugh](https://community.n8n.io/u/Tony_McHugh)\
**Post date:** [September 22, 2023, 7:10pm UTC](https://community.n8n.io/t/provide-null-value-to-notions-end-date-range/30741/7 "2023-09-22T19:10:02Z")

</div>

Cool cool, thanks for letting me know

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/195824_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [December 21, 2023, 7:10pm UTC](https://community.n8n.io/t/provide-null-value-to-notions-end-date-range/30741/8 "2023-12-21T19:10:41Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
