One of the largest Salesforce formulas - the one that returns the time in the West... · LinkedIn Posts

One of the largest Salesforce formulas - the one that returns the time in the West Coast Time zone considering DST - parsed and diagrammed for debugging:

(hopefully this link won't be truncated)
https://fernando-fernandez.github.io/FormulaDebugger/index.html?formula=IF%28+OR%28%0ADateTimeField%3C+DATETIMEVALUE%28DATE%28YEAR%28DATEVALUE%28DateTimeField%29%29%2C3%2C14%29%0A-%28WEEKDAY%28DATE%28YEAR%28DATEVALUE%28DateTimeField%29%29%2C3%2C14%29%29-1%29%29%2B10%2F24%2C+%2F*If+the+date%2Ftime+is+before+the+second+Sunday+in+March+%28end+of+wintertime%29*%2F%0ADateTimeField%3E%3D+DATETIMEVALUE%28DATE%28YEAR%28DATEVALUE%28DateTimeField%29%29%2C11%2C7%29%0A-%28WEEKDAY%28DATE%28YEAR%28DATEVALUE%28DateTimeField%29%29%2C11%2C7%29%29-1%29%29%2B10%2F24+%2F*Or+if+the+date%2Ftime+is+after+the+first+Sunday+in+November+%28start+of+wintertime%29*%2F%0A%29%2C%0AIF%28HOUR%28TIMEVALUE%28DateTimeField-8%2F24%29%29%3D0%2C%2212%22%2C%0ATEXT%28%0AHOUR%28TIMEVALUE%28DateTimeField-8%2F24%29%29%0A-IF%28HOUR%28TIMEVALUE%28DateTimeField-8%2F24%29%29%3E23%2C24%2C0%29-%0AIF%28HOUR%28TIMEVALUE%28DateTimeField-8%2F24%29%29%0A-IF%28HOUR%28TIMEVALUE%28DateTimeField-8%2F24%29%29%3E23%2C24%2C0%29%3E12%2C+12%2C0%29%29%29%2B%22%3A%22%2B%0ALPAD%28TEXT%28MINUTE%28+TIMEVALUE%28DateTimeField++%29%29%29%2C2%2C+%220%22%29%2B%0AIF%28HOUR%28TIMEVALUE%28DateTimeField-8%2F24%29%29%0A-IF%28HOUR%28TIMEVALUE%28DateTimeField-8%2F24%29%29%3E23%2C24%2C0%29%3E11%2C+%22+P%22%2C%22+A%22%29+%2F*return+the+time+portion+and+offset+it+by+8+hours+for+wintertime*%2F%0A%2C%0AIF%28HOUR%28TIMEVALUE%28DateTimeField-7%2F24%29%29%3D0%2C%2212%22%2C%0ATEXT%28%0AHOUR%28TIMEVALUE%28DateTimeField-7%2F24%29%29%0A-IF%28HOUR%28TIMEVALUE%28DateTimeField-7%2F24%29%29%3E23%2C24%2C0%29-%0AIF%28HOUR%28TIMEVALUE%28DateTimeField-7%2F24%29%29%0A-IF%28HOUR%28TIMEVALUE%28DateTimeField-7%2F24%29%29%3E23%2C24%2C0%29%3E12%2C12%2C0%29%29%29%0A%2B%22%3A%22%2B%0ALPAD%28TEXT%28MINUTE%28+TIMEVALUE%28DateTimeField+%29%29%29%2C2%2C+%220%22%29%2B%0AIF%28HOUR%28TIMEVALUE%28DateTimeField-7%2F24%29%29%0A-IF%28HOUR%28TIMEVALUE%28DateTimeField-7%2F24%29%29%3E23%2C24%2C0%29%3E11%2C+%22+P%22%2C%22+A%22%29+%2F*return+the+time+portion+and+offset+it+by+7+hours+for+summertime*%2F%0A%29%0A%2B%22M%22&run=1

SOURCE:
https://help.salesforce.com/s/articleView?id=000394902&type=1
🙏 Thanks to Eric Praud! 🙏