Hey everyone! Hopefully somebody can help point me in the right direction. I’ve created a new module in SuiteCRM to help our employees all over the world track their site visits. I have two fields for time in and time out. For the users, this works fine as everything is saved in UTC and it displays it with the User’s Timezone offset. We do however need to keep “local” timestamp somewhere in the DB so we can run reports and track visits based on the actual local time.
For example, if a user in Denver logs a visit from 9AM to 5PM, when our users in NY look at that, they are seeing 11AM to 7PM. I would like to be able to use a logic hook to create secondary “Local Time Stamp” fields so we can run reports for our users and actually see the visits in local time. I’m falling flat in my attempts. Any help would be appreciated!