# Range lookup with complex expressions

**URL:** https://forum.djangoproject.com/t/range-lookup-with-complex-expressions/26795
**Category:** Using the ORM
**Created:** [January 9, 2024, 10:49pm UTC](https://forum.djangoproject.com/t/range-lookup-with-complex-expressions/26795 "2024-01-09T22:49:54Z")
**Posts on this page:** 1
**Showing post:** 7

<div class="post-metadata">

### Author: ![KenWhitesell](https://sea2.discourse-cdn.com/flex026/user_avatar/forum.djangoproject.com/kenwhitesell/32/280_2.png) [@KenWhitesell](https://forum.djangoproject.com/u/KenWhitesell)
#### Post date: [January 10, 2024, 1:09am UTC](https://forum.djangoproject.com/t/range-lookup-with-complex-expressions/26795/7 "2024-01-10T01:09:39Z")

</div>

I just confirmed, this is a Sqlite engine issue. I can recreate your results by using _it_ as the database engine. From reading through the docs a bit more, this appears to make sense, given that Sqlite3 doesn’t have a “DateTime” data type. (See Section 3.2 at [Quirks, Caveats, and Gotchas In SQLite](https://www.sqlite.org/quirks.html))

---

_[View the full topic](https://forum.djangoproject.com/t/range-lookup-with-complex-expressions/26795)._