Definitely found the problem, but not sure yet how to fix it. It HATES
{@GMT Adjustment} as a decimal number.
Referenced formula
{@GMT Adjustment) is resolving as a 2-decimal number. I modified
{@GMT Adjustment} to round to 0:
If {Query1.ActLogAgentGmtDelta} = 0 then 0
else Round((-{Query1.ActLogAgentGmtDelta}/60),0)
Still specifies at decimal number in 2nd formula:
Does NOT work:
Date(ShiftDateTime(PDMTimeToDateTime({Query1.ActLog TimeStamp}),
"EST,300,EDT", 'UTC,' & '600.00' & ',UTC'))
DOES work:
Date(ShiftDateTime(PDMTimeToDateTime({Query1.ActLog TimeStamp}),
"EST,300,EDT", 'UTC,' & '600' & ',UTC'))
Need
{@GMT Adjustment} to display without decimal.
Edited by Kanshouzhe - 20 Dec 2012 at 4:07pm
IP Logged