Hello,
We have our database server located in Europe and our refresh rate for users set to 30 minutes for the ExpireOn and ContainersExpireOn fields. The issue we're having is that North American users are seeing a refresh rate of 6 hours and 30 minutes due to the time difference between North America and Europe. I'm assuming the procedure used to set these fields simply does a GETDATE() + 30 minutes to set the expiration, but since it's working on European time, the GETDATE is already six hours ahead. Is there a way to dynamically set this expiration to accommodate users globally? I want it to be 30 minutes for all users regardless of location; subtracting six hours from this procedure wouldn't help me because then it would put the European users in a state of constant expiration.
Thanks for any help in advance!