I have created an Access Web App that contains a macro assigned to a button to Set Value of Property to =Now() of a Text Box (of field formated as Date/Time) when clicked.
My issue is that the time is that time returned is incorrect and offset by 8hours behind current local time. The Timezone for the Site is correct and my personal timezone online for Office 365 is also correct (and also timezone of local pc).
I have heard that the offset maybe due to the Timezone setting of the SQL server but I have not found anyway to confirm this or change it even.
TLDR: Why is the Timezone returned by =Now() offset by 8 Hours from what I need?
Thanks in advance