title: Date Range search using NEST api for elastic search returning inappropriate results
body: <p>I am trying to use Date Range search in Elastic search using NEST API.</p>
  
  <p>I know that ES stores the timestamp in UTC while doing integration with Nlog.
  However, I need to a Date Range search in this @timestamp field.</p>
  
  <p>I wrote these following queries :</p>
  
  <p>From Date Search:</p>
  
  <pre><code>qcd.DateRange(r =&gt; r
                      .Field(f =&gt; f.timestamp)
                      .GreaterThanOrEquals(searchFromDateTime)
                      .TimeZone("+02:00")
                  );
  </code></pre>
  
  <p>To Date Search:</p>
  
  <pre><code>qcd.DateRange(r =&gt; r
                          .Field(f =&gt; f.timestamp)
                          .LessThanOrEquals(searchToDateTime)
                          .TimeZone("+02:00")
                      );
  </code></pre>
  
  <p>Here is the rest of the query:</p>
  
  <pre><code>searchResponse = (SearchResponse&lt;SearchEventDto&gt;)client.Search&lt;SearchEventDto&gt;(s =&gt; s
                      .Index("logstash-*")
                      .Type("logevent")
                      .Query(q =&gt; qcd)
                  );
  </code></pre>
  
  <p>SearchFromDateTime or SearchToDateTime are c# dates.</p>
  
  <p>Clearly, there is something wrong in the queries, because, it does not take into account the time difference. </p>
  
  <p>For example, since I am CET time, if I give 28.06.2019 14:48 as Search From Date, it should search from 28.06.2019 12:48. Or, the same should happen in Search To date too.</p>
  
  <p>Any idea, how I can achieve this ?</p>