# Adding a date parameter

**URL:** <https://meta.discourse.org/t/adding-a-date-parameter/276158>\
**Category:** Data & reporting\
**Tags:** sql-tutorial\
**Created:** [August 22, 2023, 9:18am UTC](https://meta.discourse.org/t/adding-a-date-parameter/276158 "2023-08-22T09:18:23Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Jagster](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jagster/32/192154_2.png) [@Jagster](https://meta.discourse.org/u/Jagster)\
**Post date:** [August 22, 2023, 1:06pm UTC](https://meta.discourse.org/t/adding-a-date-parameter/276158/2 "2023-08-22T13:06:23Z")

</div>

```plaintext
PG::SyntaxError: ERROR: syntax error at or near ":"
LINE 16: WHERE p.created_at::date BETWEEN :start_date AND :end_date -…

```

😫

---

_[View the full topic](https://meta.discourse.org/t/adding-a-date-parameter/276158)._