# Filter on datetime with Data service

**URL:** <https://forum.litium.com/t/filter-on-datetime-with-data-service/198>\
**Category:** Questions\
**Tags:** accelerator, data-service\
**Created:** [August 20, 2018, 6:47am UTC](https://forum.litium.com/t/filter-on-datetime-with-data-service/198 "2018-08-20T06:47:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ericsj11](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/ericsj11/32/899_2.png) [@Ericsj11](https://forum.litium.com/u/Ericsj11)\
**Post date:** [August 20, 2018, 6:47am UTC](https://forum.litium.com/t/filter-on-datetime-with-data-service/198/1 "2018-08-20T06:47:11Z")

</div>

Is it possible to use a datetime field as filter with data service?

The case is: I want to get all products with a custom datetime field where the date is Greater than 1 week ago.

Data service ref: [https://docs.litium.com/documentation/architecture/data-service](https://docs.litium.com/documentation/architecture/data-service)  
Litium version: 5.5

---

<div class="post-metadata">

**Author:** ![Ericsj11](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/ericsj11/32/899_2.png) [@Ericsj11](https://forum.litium.com/u/Ericsj11)\
**Post date:** [August 20, 2018, 2:38pm UTC](https://forum.litium.com/t/filter-on-datetime-with-data-service/198/2 "2018-08-20T14:38:14Z")

</div>

If thats not possible, could you provide some documentation on the “should” filter please?

---

<div class="post-metadata">

**Author:** ![marten](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/marten/32/11_2.png) [@marten](https://forum.litium.com/u/marten)\
**Post date:** [August 21, 2018, 6:30am UTC](https://forum.litium.com/t/filter-on-datetime-with-data-service/198/3 "2018-08-21T06:30:38Z")

</div>

This is tested on a 6.2 installation but should be the same in 5.5:

```auto
// Operators for DateTime: null, any, eq, gt, gte, lt, lte, neq 
using (var query = _dataService.CreateQuery<BaseProduct>(opt => opt.IncludeVariants()))
{
   var q = query.Filter(filter => filter
      .Bool(boolFilter => boolFilter.Must(boolFilterMust => boolFilterMust
         .Field("TestDateTime", "gt", DateTime.Now.AddDays(-7))
         .Field("TestDateTime", "neq", "null"))
   ));
   return q.ToList();
}

```