Help

DateTime add is not working correctly

Topic Labels: Dates & Timezones
421 1
cancel
Showing results for 
Search instead for 
Did you mean: 
james_turner
4 - Data Explorer
4 - Data Explorer

Here’s all the info:

The formula is subtracting time when it should be adding time.

Here’s the beginning time settings
image

Here’s the formula settings
image

It should be adding one hour to the time, but instead it’s subtracting 7 hours.
image

Any help would be great!

1 Reply 1

Those 2 fields are in different time zones. You’ll need to adjust your formatting on each field to have matching time zones.