DATEVALUE() formula fields are incorrect in Reports and Visualforce due to daylight savings
Last updated 6 days ago ·Reference W-869341 ·Reported By 211 users
Reports and Visualforce components relying on a Date/Time format field may be off by an hour during Daylight Savings Time.
Formulas using the DateValue() function display as being off by one hour when displayed on Reports or Visualforce.
It is recommended that date/time fields that intend to have the DateValue() function used on it should not be defined between 11pm and 1am. Doing so may cause the Date to be translated into an incorrect Date.
Alternately, updating your user timezone may return desirable results.
Reported By (211)
Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.