Make Dynamic Date/Time Functions Respond to the Company Time Zone
The dynamic date and time functions—such as CURRENT_DATE() and NOW()—are represented in UTC, regardless of the Company Time Zone in your Admin Settings. This creates a problem during the hours of the day when the UTC date and your company time zone's dates are unaligned. For instance, say you have a Beast Mode that uses…