What data type for custom field timezone offset?

Product Support
1

What data type works for custom field that would use timezone offset? I’ve tried all of them and the most I get is the 3 string indicator “420” for timezone offset.

2

Thanks for that I figured that out only 30 minutes ago. The other issue is the date and time stamps.

I changed the date and time format to: Y-n-d G:i:s for all date/time fields in the configuration and finally I’m able to see the time in 24 hour format, but the hour seconds and minutes are still coming out as 00:00:00 even though they exist in the backend MySQL database.

I also noticed the referring URL exists in the backend database but it never shows in reports.

So what’s up with that?

Thank you