# DSL query thats compares the same data from different dates

**URL:** https://discuss.elastic.co/t/dsl-query-thats-compares-the-same-data-from-different-dates/137763
**Category:** Elasticsearch
**Created:** [June 28, 2018, 8:20am UTC](https://discuss.elastic.co/t/dsl-query-thats-compares-the-same-data-from-different-dates/137763 "2018-06-28T08:20:22Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![lutundula\_jeanchris](https://avatars.discourse-cdn.com/v4/letter/l/919ad9/32.png) [@lutundula\_jeanchris](https://discuss.elastic.co/u/lutundula_jeanchris)
#### Post date: [June 28, 2018, 8:20am UTC](https://discuss.elastic.co/t/dsl-query-thats-compares-the-same-data-from-different-dates/137763/1 "2018-06-28T08:20:23Z")

</div>

Hello everyone , i'am trying to make a query like that in DSL , the goal is to be able compare terms based on a date range . is it possible to do that we DSL Query ?  
Query :

SELECT  
fqdn  
FROM  
visited\_urls  
WHERE  
MIN(date\_visited) BETWEEN CURDATE() AND CURDATE() - 1  
AND fqdn NOT IN (  
SELECT DISTINCT fqdn  
FROM  
visited\_urls  
WHERE  
date\_visited BETWEEN CURDATE() - 2 AND CURDATE() - 30

Kind regards

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 26, 2018, 8:20am UTC](https://discuss.elastic.co/t/dsl-query-thats-compares-the-same-data-from-different-dates/137763/2 "2018-07-26T08:20:24Z")

</div>

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