title: Not getting any rows from query but there are rows available in the table
body: <pre><code>AND (
      (datediff(DAY,getdate(), '2020-07-14 00:00:00.000') = 5)
      OR (
          datediff(DAY,getdate(), A.HX_RELIEVING_DT) BETWEEN 0 AND 4
          AND '2020-04-17 20:36:53.000' &gt;= GETDATE()-1
      )
  ) 
  </code></pre>
  <p>This is the output I want for relieving date and last updated time but I am unable to get this</p>
  <pre><code> EMPLID LOCATION    SUPERVISOR_ID    HX_RELIEVING_DT               LASTUPDDTTM
   -- SINGAPORE          ---        2020-07-14 00:00:00.000       2020-04-17 20:36:53.000
  </code></pre>