title: Why is the grid showing 4hrs before than the time it has in the database
body: <p>I have a problem showing the Date and Time on a Grid on Acumatica. it is supposed to show the exact same time it has on the database but instead is showing 4 hours before like its a TimeZone issue.</p>
  <p>My code is like this:</p>
  <p>DAC definition</p>
  <pre><code>#region TodaysDate
  public abstract class todaysDate : PX.Data.IBqlField
  {
  }
  
  [PXDBDateAndTime(UseTimeZone = false, PreserveTime = true, DisplayNameDate = &quot;Date&quot;, DisplayNameTime = &quot;Time&quot;)]
  [PXDefault(typeof(AccessInfo.businessDate))]
  public virtual DateTime? TodaysDate { get; set; }
  #endregion
  </code></pre>
  <p>Aspx definition</p>
  <pre><code>&lt;px:PXGrid ID=&quot;grid&quot; runat=&quot;server&quot; DataSourceID=&quot;ds&quot; Style=&quot;z-index: 100&quot; 
      Width=&quot;100%&quot; Height=&quot;150px&quot; SkinID=&quot;Details&quot; TabIndex=&quot;4200&quot;&gt;
      &lt;Levels&gt;
          &lt;px:PXGridLevel DataKeyNames=&quot;OrderType,OrderNbr,TodaysDate&quot; DataMember=&quot;TruckCheckRecord&quot;&gt;
              &lt;RowTemplate&gt;
                  &lt;px:PXDateTimeEdit ID=&quot;edTodaysDate&quot; runat=&quot;server&quot; AlreadyLocalized=&quot;False&quot; DataField=&quot;TodaysDate&quot; IsClientControl=&quot;True&quot; InputMask=&quot;hh:mm&quot;&gt;
                  &lt;/px:PXDateTimeEdit&gt;
              &lt;/RowTemplate&gt;
              &lt;Columns&gt;
                  &lt;px:PXGridColumn DataField=&quot;OrderType&quot;&gt;
                  &lt;/px:PXGridColumn&gt;
                  &lt;px:PXGridColumn DataField=&quot;OrderNbr&quot;&gt;
                  &lt;/px:PXGridColumn&gt;
                  &lt;px:PXGridColumn DataField=&quot;BAccount__AcctName&quot; Width=&quot;120px&quot;&gt;
                  &lt;/px:PXGridColumn&gt;
                  &lt;px:PXGridColumn DataField=&quot;Trucker&quot; Width=&quot;120px&quot;&gt;
                  &lt;/px:PXGridColumn&gt;
                  &lt;px:PXGridColumn DataField=&quot;Contno&quot; Width=&quot;120px&quot;&gt;
                  &lt;/px:PXGridColumn&gt;
                  &lt;px:PXGridColumn DataField=&quot;Seal&quot; Width=&quot;120px&quot;&gt;
                  &lt;/px:PXGridColumn&gt;
                  &lt;px:PXGridColumn DataField=&quot;Outside&quot;&gt;
                  &lt;/px:PXGridColumn&gt;
                  &lt;px:PXGridColumn DataField=&quot;Inside&quot;&gt;
                  &lt;/px:PXGridColumn&gt;
                  &lt;px:PXGridColumn DataField=&quot;Opening&quot;&gt;
                  &lt;/px:PXGridColumn&gt;
                  &lt;px:PXGridColumn DataField=&quot;Temp&quot;&gt;
                  &lt;/px:PXGridColumn&gt;
                  &lt;px:PXGridColumn DataField=&quot;Pests&quot;&gt;
                  &lt;/px:PXGridColumn&gt;
                  &lt;px:PXGridColumn DataField=&quot;Pesticides&quot;&gt;
                  &lt;/px:PXGridColumn&gt;
                  &lt;px:PXGridColumn DataField=&quot;Documents&quot;&gt;
                  &lt;/px:PXGridColumn&gt;
                  &lt;px:PXGridColumn DataField=&quot;Employee&quot; Width=&quot;120px&quot;&gt;
                  &lt;/px:PXGridColumn&gt;
                  &lt;px:PXGridColumn DataField=&quot;TodaysDate&quot; Width=&quot;102px&quot; DisplayFormat=&quot;g&quot;&gt;
                  &lt;/px:PXGridColumn&gt;
              &lt;/Columns&gt;
          &lt;/px:PXGridLevel&gt;
      &lt;/Levels&gt;
      &lt;AutoSize Container=&quot;Window&quot; Enabled=&quot;True&quot; MinHeight=&quot;150&quot; /&gt;
  &lt;/px:PXGrid&gt;
  </code></pre>
  <p>I've tried variations on the DAC to see if that solves the problem but it always shows the result as the following</p>
  <p>Values shown in gridview:</p>
  <p><a href="https://i.stack.imgur.com/3TJR8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3TJR8.png" alt="enter image description here" /></a></p>
  <p>Database values for the same records</p>
  <p><a href="https://i.stack.imgur.com/7g64c.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7g64c.png" alt="enter image description here" /></a></p>
  <p>Does anybody know how to solve this?</p>