<< Click to Display Table of Contents >>
Navigation: Tips & Tricks >
Time Zones & what date/time displays
AyaNova Administrator logged in with no Time Zone Override set with server located in PST (Pacific Time Zone)
Ryan Moody logged in with Time Zone Override of -5 set (5 hours less than GMT)
Time zones and their relation to how you have connected to the AyaNova database:
All dates/times in AyaNova are stored in the AyaNova database in GMT. How the AyaNova date/time data displays to the user depends on the time zone of that users computer.
By default, the time zone of that users computer is used if connecting via a direct network connection configuration. If connecting via anything else (WBI, MBI, data portal) than the time zone where the WBI server, Data Portal server, and/or MBI server resides is used.
If a user is in a different time zone than where the server is set for and the user wants to view date/times based on where he actually is, then:
1. the AyaNova Administrator will want to edit that user's Override TimeZone field in that user's entry screen in the Windows AyaNova application to account for the different time zone
2. or the user can edit themselves via WBI in their [username] navigation pane area if have Read/Write to Object.User
•The AyaNova database is configured for network use in an office in California (Pacific Time Zone).
•The time right now is 12:00PM (noon) Pacific Time Zone on November 12 2009 on the server where the AyaNova database resides.
•Bob the dispatcher is connecting to the AyaNova database from within the local area network of this office using the network SQL connection configuration in his config.txt file. His workstation also says 12:00PM as he is of course on the same time time zone and the same time as the server being in the same local area network.
•Bob's user entry screen field Override TimeZone does not need to be edited as he will be using the same time zone as the server:
•Bob creates a new workorder and enters the Request Date/Time as today 12:00PM (noon) and saves the workorder.
•Do note that although Bob has entered 12:00PM into this field, it is actually saved in the AyaNova database as 7:00PM GMT so that it can be converted from GMT to whatever time zone any other user is using.
•Ryan another AyaNova user with this same database, is in New York (Eastern Time Zone) where it is 3:00PM right now on his computer (its 12:00PM in California where the server is)
•Ryan connects to the AyaNova database in California via a data portal connection configuration in his config.txt file
•If Ryan's Override TimeZone is left at the default of empty, if he views that workorder just created by Bob, the Request Date/Time will show as 12:00PM to Ryan, even though it is actually 3:00PM right now in New York.
•So Ryan will want to have the AyaNova Administrator edit Ryan's user entry screen's field Override TimeZone to -5 to offset any times to show in New York time. (-5 means 5 hours behind GMT at this time of the year)
•Sally another AyaNova user is in Texas (Standard Time Zone) where it is 2:00PM right now on her computer (its 12:00PM in California where the server is)
•Sally connects directly to the AyaNova database in California via a high speed VPN network connection using the network SQL connection configuration in her config.txt file.
•Sally views the same just created workorder
•The Request Date/Time will show as 2:00PM - not 12:00PM
•This is because Sally is connecting via a network connection configuration, and therefore the time zone of Sally's computer dictates what time zone to use for display.
•Sally's user entry screen field Override TimeZone does not need to be edited as she is using her computer's time zone. But it would still be recommended to do so for consistency so with daylight saving time, her Override TimeZone field would be edited to -6 (6 hours behind GMT).
•Hank another AyaNova user is located in New York (Eastern Time Zone) where it is 3:00PM right now on his computer (its 12:00PM in California where the server is)
•Hank connects over the internet to the AyaNova database by logging in via WBI
•Hank views this same just created workorder
•The Request Date/Time will show as 12:00PM because the WBI server is running on the California server that is using Pacific Time Zone, but he wants to see what the time would be for him where he actually is.
•Hank will want to edit his username's Override TimeZone setting in WBI entering and saving -5 (as Standard Time Zone is 6 hours behind GMT at this time of the year)
•NOTE: The security group Hank belongs to must have Read/Write access to Object.User to be able to edit the Override TimeZone via WBI