NOW time off by 2 hours

Hello
NOW in server connect uses the server time, not the user local time.
You can use NOW_UTC instead and store the time in UTC time zone instead.

Or you can take the users local time from the front end, using the Date and Time component and store its value into some hidden field: