I have multiple users across the US using my application and I utilized the now() function. So is there way to convert all of these now() to eastern standard time because these time stamps are saved in my access database.
I believe that NOW() is dependent on your regional time settings (I am in the Eastern Time Zone), and NOW() returns the correct time.
So, if it returns something different for you, then your regional time settings is probably something other than Eastern Time, so you would just need to offset your time by that.
You can do that by adding/subtracting the difference in hours divided by 24, i.e. =Now() + (hours/24) or =Now() - (hours/24) where hours is the difference in hours between your regional settings and the Eastern time zone