title: How to retrieve data from azure table storage between date and time
body: <p>I am trying to retrieve data between 2 dates from table storage using logdatetime column in my table, i end up getting this </p>
  
  <blockquote>
    <p>{"Result":[],"Id":11,"Exception":null,"Status":5,"IsCanceled":false,"IsCompleted":true,"IsCompletedSuccessfully":true,"CreationOptions":0,"AsyncState":null,"IsFaulted":false}</p>
  </blockquote>
  
  <p>instead of data between those 2 days. FYI id hardcoded, from datetime and to datetime.</p>
  
  <pre><code>            CloudTableClient tableClient = storageAccount.CreateCloudTableClient();              
  
              string partitionFilter = TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "partitionkey");
  
              string finalFilter = TableQuery.CombineFilters(
                                      TableQuery.CombineFilters(partitionFilter, TableOperators.And, "logdatetime eq datetime'2019-03-17T19:09:26.0000000Z'"), TableOperators.And, "logdatetime eq datetime'2019-03-17T19:10:16.0000000Z'");
  
              var query = new TableQuery&lt;TelemetryData&gt;().Where(finalFilter);
              CloudTable table = tableClient.GetTableReference("TableName");
              var result = table.EndExecuteQuerySegmented(query,null);
  </code></pre>