Microsoft Dynamics Support

IMRTD · Guest

Hi All,

I am a bit curious about how AX4.0 supports GMT time zones. Lets say i
create an EDT of Date type and use it on a form. The data in this EDT will be
stored with time component as well into the database and this time will not
be GMT. Is there anyway in Axapta to store date and time data that recognizes
GMT time zone?

Regards

Nitin Goyal · Guest

I think this feature is not available in Ax 4.0. Thanks, Nitin

"IMRTD" wrote:

Guest · Posted: Mon Sep 17, 2007 8:32 pm Post subject: Re: Universal Time Issues

On Sep 14, 1:58 pm, Nitin Goyal <NitinGo...@discussions.microsoft.com>
wrote:

bpskiles · Guest

I had this problem as well. There is a way to display a time in the user's
local time zone, but it's ugly. It works very well, though. My users are
happy with it. Let me know if you make any improvements, as I'd like to see
any. Also, let me know if you have any questions.

I created a table called 'TimeZoneCalculator'
I changed properties CreatedDate and CreatedTime to Yes.
It has two fields: CurrentTime (time) and SessionId (int)

There are 3 static methods on the table (code below):
GetLocalTimeFromServerTime
GetLocalTimeOffset
GetServerTimeFromLocalTime

static TimeOfDay GetLocalTimeFromServerTime(TimeOfDay serverTime)
{
return serverTime - TimeZoneCalculator::GetLocalTimeOffset();
}

static TimeOfDay GetServerTimeFromLocalTime(TimeOfDay localTime)
{
return localTime + TimeZoneCalculator::GetLocalTimeOffset();
}

static int GetLocalTimeOffset()
{
timeOfDay t;
TimeZoneCalculator tzc;
Session s;
int offset;
str cacheName;
;
// store stuff in the globalcache to speed lookups
s = new xSession();
// sessionid is added to the cache name so that a user
// can have multiple sessions in different time zones.
cacheName = "time_offset_" + int2str(s.sessionId());
if (infolog.globalCache().isSet(curuserid(), cacheName)) {
// don't bother calculating it again
return any2int(infolog.globalCache().get(curuserid(), cacheName));
} else {
ttsbegin;
// delete anything that already exists
delete_from tzc where tzc.SessionId == s.sessionId();
tzc.SessionId = s.sessionId();
// set current time to the client's local time
tzc.CurrentTime = timenow();
tzc.insert();
tzc.write();
// created time will get populated here
ttscommit;
select tzc where tzc.SessionId == s.sessionId();
// calculate the offset
offset = tzc.createdTime - tzc.CurrentTime;
// add it to the global cache for good luck!
infolog.globalCache().set(curuserid(), cacheName, offset);
return offset;
}
}

"IMRTD" wrote: