title: How to pull relative date/time using getdate in SQL whereclause
body: <p>I have a need to pull data from a previous full calendar day. I am using:</p>
  <p><code>'(authdate &gt;=''' + formatdatetime('MM/DD/YYYY',getdate-2) +''') and (authdate &lt;=''' + formatdatetime('MM/DD/YYYY',getdate-1) +''')</code></p>
  <p>However since it is using EST and client is in CST, it is pulling an hour off of what I need. How do I modify this getdate to give me &gt;=47 hours ago and &lt;=23 hours ago ?</p>