Automations, Dates, and Timezones!

Question

Our server is set for EST and we have some automations that work odd date and time. If today is before x date, do this. We ran into an issue where our date checks are not working as expected. Whats the best way to handle this? 
 var startDate = new Date(core_v2_widget.GetDateTimeValue('startDate'));
 var endDate = new Date(core_v2_widget.GetDateTimeValue('endDate'));
 if( (core_v2_utility.CurrentDate >= startDate) && (core_v2_utility.CurrentDate <= endDate)){

Patrick M. · Answer

You are comparing dates that are potentially in 2 different timezones. CurrentDate is always server time, GetDateTimeValue is always User time, or converted based on the user's timezone setting. To get a proper evaluation, you need to have them all the same DateTime.Kind. If its an automation run under the service account then make all the dates the same by using core_v2_utility.CurrentUserDate.

Automations, Dates, and Timezones!

Top Replies