Hi, I'm facing an administration problem. The company I work for has multiple DNN installation in one server, and each of those installation can have one or more portals each. All the installation has the database in the same SQL instance, each installation uses a different SQL user and database (but again, same SQL Server instance). Some of this sites are used from Australia, Japan, others from US. Currently the database server is configured to use EST time zone. So, when the administrators at Australia set a role to start today, and they do it during the morning, when the completed, the user has the role, but is not active, because the activation date is compared with today date in the server, and that's a day behind.
Server Time Eastern (UTC -4): Jun 8 2:12pm
Admin User time Sydney (UTC +10): Jun 9 4:12am
So, the Admin sets start date for Jun 9, and the role will not start immediately, it will start 10 hours after.
This is not the issue, but in my Case this is really important, it is an eLearning site, the admin assigns content to users (courses), and the admins are not real System Admins, just know about the content. The only solution is to explain to the Admins that they have to use the server time? is there any possible solution using each user time?