(Solved) Bug: thisRow.Created() off by -1 seconds when adding hours(x)

Suggestion Box
1

==SOLVED: See next post. ==

So bc of Time Zones, I have to add Hours(2) :

// Returns: thisRow.Created() rounded by nearest 5 minutes
Hours(2) + thisRow.Created().DateTimeTruncate(“hour”) + RoundTo(thisRow.Created().Minute(),5)

This returns 10:04:59 instead of 10:05:00.

If I leave out the Hours(2), however, it does work normal.

thisRow.Created().DateTimeTruncate(“hour”) + RoundTo(thisRow.Created().Minute(),5)

This returns 08:05:00

2

EDIT
Never mind, it was a bad equation. I think the last part was returning a Number >.< .

Fixed:

Hours(2) + thisRow.Created().DateTimeTruncate(“hour”) + Minutes( RoundTo(thisRow.Created().Minute(),5) )