Datetime field not converting correctly based on user timezone setting

  • 1
  • Problem
  • Updated 3 years ago
  • Solved
  • (Edited)
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: This has been resolved in Rockaway 8.11

When a user with a timezone setting of PDT sets a datetime to 03/21/2016 11:00 PM, the value displayed to a user with a timezone setting of EDT is 03/21/2016 2:00am when it should be 03/22/2016 2:00am.  Also, when timezone is EDT, the value saved is not the actual value input.

Steps to reproduce:
1) Create page using XML below
2) Set timezone to (GMT-07:00) Pacfic Daylight Time (America/Los_Angeles)
3) Preview page picking an existing Task
4) Set the reminder datetime field to "03/21/2016 11:00 PM"
5) Save the record
6) Set timezone to (GMT-04:00) Eastern Daylight Time (America/New_York)
7) Refresh page

Expected Result
Reminder Date/Time is 03/22/2016 2:00 AM

Actual Result
Reminder Date/Time is 03/21/2016 2:00 AM

8) With the timezone still EDT, set the date to 3/26/2016 and time to 1:00AM
9)  Click Save

Expected Result
The date should display as 3/26/2016 1:00AM

Actual Result
The date displays as 3/25/2016 1:00AM

Sample Page XML
<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" showheader="true" tabtooverride="Task">   <models>
      <model id="Task" limit="1" query="true" createrowifnonefound="true" sobject="Task" adapter="" type="">
         <fields>
            <field id="Subject"/>
            <field id="CreatedDate"/>
            <field id="ReminderDateTime"/>
         </fields>
         <conditions>
            <condition type="param" value="id" field="Id" operator="=" enclosevalueinquotes="true" novaluebehavior=""/>
         </conditions>
         <actions/>
      </model>
   </models>
   <components>
      <pagetitle model="Task" uniqueid="sk-2RnJl6-70">
         <maintitle>
            <template>{{Subject}}</template>
         </maintitle>
         <subtitle>
            <template>{{Model.label}}</template>
         </subtitle>
         <actions>
            <action type="savecancel" window="self"/>
         </actions>
      </pagetitle>
      <basicfieldeditor showsavecancel="false" showheader="true" model="Task" mode="edit" uniqueid="sk-2RnJl6-71" buttonposition="">
         <columns>
            <column width="50%">
               <sections>
                  <section title="Basics">
                     <fields>
                        <field id="Subject"/>
                        <field id="ReminderDateTime" valuehalign="" type=""/>
                     </fields>
                  </section>
               </sections>
            </column>
            <column width="50%">
               <sections>
                  <section title="System Info">
                     <fields>
                        <field id="CreatedDate"/>
                     </fields>
                  </section>
               </sections>
            </column>
         </columns>
      </basicfieldeditor>
   </components>
   <resources>
      <labels/>
      <css/>
      <javascript/>
   </resources>
   <styles>
      <styleitem type="background" bgtype="none"/>
   </styles>
</skuidpage>
Photo of Barry Schnell

Barry Schnell, Champion

  • 18,206 Points 10k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Ben Hubbard

Ben Hubbard, Employee

  • 12,530 Points 10k badge 2x thumb
Thanks Barry,

I was able to reproduce this. We should have a fix out for this in our next patch.
Photo of Barry Schnell

Barry Schnell, Champion

  • 18,206 Points 10k badge 2x thumb
Awesome, thanks Ben!
Photo of Barry Schnell

Barry Schnell, Champion

  • 18,206 Points 10k badge 2x thumb
Hey Ben - FYI that this might be the same or related.

https://community.skuidify.com/skuid/topics/format-date-adjusting-for-timezone
Photo of Barry Schnell

Barry Schnell, Champion

  • 18,206 Points 10k badge 2x thumb
Hey Ben - I just tested this with 8.8 and it still appears to be not working correctly.  Did the fix you mentioned above make it out the door?
Photo of Ben Hubbard

Ben Hubbard, Employee

  • 12,530 Points 10k badge 2x thumb
Unfortunately, this one didn't make it.
Photo of Barry Schnell

Barry Schnell, Champion

  • 18,206 Points 10k badge 2x thumb
Thanks for the update Ben.  Still on the near-term roadmap to be fixed?
Photo of Barry Schnell

Barry Schnell, Champion

  • 18,206 Points 10k badge 2x thumb
Hey Ben - FYI on the issue at https://community.skuid.com/skuid/topics/ui-only-formula-field-not-evaluating-date-field-correctly?u... that is likely the same/similar but dealing with date fields not datetime fields.
Photo of Ben Hubbard

Ben Hubbard, Employee

  • 12,530 Points 10k badge 2x thumb
This should be fixed as of Rockaway 8.11 and Banzai 7.36.9. Both releases are available at skuid.com/releases.

This conversation is no longer open for comments or replies.