Krishna Khemraj
New Member
Situation:
I have a model that pushes records onto SQL Server and I'm using the NOW() formula to put a date stamp on the record before it gets pushed.
Problem:
The problem is that if someone in New York pushes a change in and then someone in California has an update and pushes it in a few minutes later, The server thinks the New York entry is the most current.
Ask:
How can I create a custom function to pull the current time in UTC-06:00? I could feed that into the record that gets pushed into a shared server and all entries will have a normalized time/date.
I have a model that pushes records onto SQL Server and I'm using the NOW() formula to put a date stamp on the record before it gets pushed.
Problem:
The problem is that if someone in New York pushes a change in and then someone in California has an update and pushes it in a few minutes later, The server thinks the New York entry is the most current.
Ask:
How can I create a custom function to pull the current time in UTC-06:00? I could feed that into the record that gets pushed into a shared server and all entries will have a normalized time/date.
