When applying FORMAT_DATE function to a DATE field, the resulting output is adjusting the DATE based on the timezone.

Note - This might be related to https://community.skuid.com/t/datetime-field-not-converting-correctly-based-on-user-ti…

Steps to Reproduce:

1. Add field “Test_Date__c” to Account object as a DATE field


2. Set SFDC timezone setting to make sure you are on a prior day from 00:00 GMT


3. Create page using XML below


4. Preview page

Expected Behavior

Test_Date__c == Formatted Date

Actual Behavior

Test_Date__c is correct

Formatted Date has adjusted for timezone (mine is PDT)

Sample Page XML

<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" showheader="true" tabtooverride="Account">   <models>

      <model id="Account" limit="1" query="true" createrowifnonefound="false" sobject="Account" adapter="" type="">

         <fields>

            <field id="Name"/>

            <field id="CreatedDate"/>

            <field id="FormattedDate" uionly="true" displaytype="FORMULA" label="Formatted Date" readonly="true" returntype="TEXT">

               <formula>FORMAT_DATE('mm/dd/yy', {{Test_Date__c}})</formula>

            </field>

            <field id="Test_Date__c"/>

         </fields>

         <conditions>

            <condition type="param" enclosevalueinquotes="true" operator="=" field="Id" value="id"/>

         </conditions>

         <actions/>

      </model>

   </models>

   <components>

      <pagetitle model="Account" uniqueid="sk-3QEmlF-70">

         <maintitle>

            <template>{{Name}}</template>

         </maintitle>

         <subtitle>

            <template>{{Model.label}}</template>

         </subtitle>

         <actions>

            <action type="savecancel" window="self"/>

         </actions>

      </pagetitle>

      <basicfieldeditor showsavecancel="false" showheader="true" model="Account" mode="read" uniqueid="sk-3QEmlF-71">

         <columns>

            <column width="100%">

               <sections>

                  <section title="Basics">

                     <fields>

                        <field id="Name"/>

                        <field id="Test_Date__c" valuehalign="" type=""/>

                        <field id="FormattedDate" valuehalign="" type=""/>

                     </fields>

                  </section>

               </sections>

            </column>

         </columns>

      </basicfieldeditor>

   </components>

   <resources>

      <labels/>

      <css/>

      <javascript/>

   </resources>

   <styles>

      <styleitem type="background" bgtype="none"/>

   </styles>

</skuidpage>