Unexpected adjustments from Formula Field Date/Time (Adjust to user time zone) and Date/Time...

Hi,

I've have two objects with relationship: Many Opportunities to Many Events. When I try to find the earliest Event for an Opportunity using a Formula Field I'm seeing the wrong local time adjustment being applied and this leads to an incorrect date difference for me.

var date = rbv_api.selectValue("SELECT min(startDate) FROM obj_event WHERE eventOpportunity = ?", {!id});
rbv_api.println(date);
return date;

My earliest Event is Thu May 18 2017 00:30 as entered client side UI.

With Formula Field: Date/Time (Do not adjust):
Debug: 2017-05-17 23:30:00.0 - as expected
Return: Wed May 17 2017 22:30:00 (IST) - this seems 1 hour too early I'm expecting Wed May 17 2017 23:30:00 (UTC)

With Formula Field: Date/Time (Adjust to user time zone)
Debug: 2017-05-17 23:30:00.0 - as expected
Return: Wed May 17 2017 23:30:00 (IST) - this seems 1 hour too early I'm expect local time of Thu May 18 2017 00:30

Time Zone: (GMT) Greenwich Mean Time (IST) Europe/Dublin, ZoneInfo[id="Europe/Dublin",offset=0,dstSavings=3600000,useDaylight=true,...]
Release 4.5.2.0

Cheers
--
Charles

Continue reading...