title: Is it possible to subtract 6hrs from DateDiff?
body: <p>I am using the access query below to do some calculations. Because the server is located in Europe but the users of the application are in the US, there is a difference of 6 hours. In the command below, can I some how accommodate for this? So that when running the command it does the datediff minus 6 hours somehow?</p>
  
  <pre><code>Days Waiting : IIf([Datereceivedunit] Is Null,0,IIf([QuoteFrom] Is Null,DateDiff("d",[Datereceivedunit],Date())-(DateDiff("ww",[Datereceivedunit],Date())*2),0))
  </code></pre>