Get Accurate Daylight Savings Time Values with DATEVALUE()

The DATAVALUE() formula option provides more accurate daylight savings time values without workarounds. The option avoids an existing one-hour discrepancy when processing times between 11:00 PM and 1:00 AM.

Where: This change applies to Lightning Experience and Salesforce Classic in all editions.

How: From Setup, in the Quick Find box, enter Company Information. Under Locale Settings, select Improve DATEVALUE() accuracy for DST.Screen image of checkbox to enable improved datevalue option.


If your org's custom formulas include workarounds that adjust date values between 11:00 PM and 1:00 AM, remove them before enabling this setting. If you do not remove the workarounds, your data could be inaccurate. Enabling the preference can also increase the compiled size of existing formulas with the DATEVALUE() function.