ramgopal.kotha Posted December 17, 2013 Report Share Posted December 17, 2013 Hi All, I am in india. How to get other country(US/Canda) date and time using Macros. (Or) How to get other country date and time using Macros. ThanksRam Quote Link to comment Share on other sites More sharing options...
Cory Posted December 17, 2013 Report Share Posted December 17, 2013 I don't understand exactly what you are asking for. If you want to get the time for another country than what the local machine is operating use the Variable Modify Date/Time with the "Integer or Value:" option to add or subtract the number of hours. The one oddity here is that you might have to do two operations since much of India has the distinction of being in a half-hour time zone! You guys are weird. So you need to add/subtract the number of hours then 30 minutes since it only accepts integer values. Don't forget the US is vast and covers 5 time zones. Also not all of our states observe Daylight Saving Time. What's more the exact days of DST observance varies from country to country so by no means is calculating time someplace else a simple proposition. Quote Link to comment Share on other sites More sharing options...
ravisatuluri Posted December 17, 2013 Report Share Posted December 17, 2013 Hi Cary, Thansk for sharing the information.. I have one question on related this post.. If we are working with the different time zones and our macro is used accross the globe, in this case we need to identify the central time zone and subtract from the local time. in this case how we can find the server time when the macro running in server. Quote Link to comment Share on other sites More sharing options...
Cory Posted December 17, 2013 Report Share Posted December 17, 2013 By "central time" I assume you mean UTC/GMT. Your language is confusing because there is a "Central" time zone in the US which is UTC-6. Time in computers is generally save in UTC with an 'offset'. It sounds like you want UTC so in that case I would simply get the UTC time from WMI and not deal with all the hassles of the math. So right now my computer things the time is 5:05 PM with an offset of -8 making it appear as 9:05AM to me. Just search the MSDN for WMI and system time. Or search the internet for a VBScript that will return system time in UTC. Quote Link to comment Share on other sites More sharing options...
Look_Up Posted December 18, 2013 Report Share Posted December 18, 2013 (edited) - Post deleted, no really useful information - Timezones Edited December 18, 2013 by Look_Up Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.