How to convert string to UTCDateTime?

(0) Share

Report

Posted on by junior AX

1,552

Hi,

I have the following:

str dateString = "Sunday, 21 Feb 2010 19:05:15 GMT"

how can i convert this to UTCDateTime?

I have the same question (0)

All responses (4)

Answers (0)

zhifeng Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Please refer this thread: https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/125802/converting-string-into-datetime

Was this reply helpful? Yes No
Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
HI Junior,

You can convert RFC1123 string time format to DateTime,and then convert it to UTCDateTime.

DateTime zdt = DateTime::Parse("Thu, 25 Aug 2016 08:59:00 GMT" ); udateTime = Global::CLRSystemDateTime2UtcDateTime(zdt);

Was this reply helpful? Yes No
HenryXie Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi

Dynamics AX 2012 utilizes the utcDateTime data type to store date time information in the database using the Greenwich Mean Time definition of time. This allows the data to be date stamped in a manner that does not reflect the client or AOS time zone (this date/time stamp is considered to be time zone agnostic).

DateTimeUntil class: https://docs.microsoft.com/en-us/previous-versions/dynamics/ax-2012/system-classes/gg837448(v=ax.60)?redirectedfrom=MSDN

static void DateConvert(Args _args)
{
    UTCDateTime myDateTime,gmtDateTime;
    str         strDate;
    //The sequence 123 describes the position of day (1), month (2), year (3).
    int         intSeq;

    Timezone    myTimeZone = Timezone::GMTPLUS0800BEIJING_CHONGQING_HONGKONG;
    ;
// Sunday, 21 Feb 2010 19:05:15 GMT
    strDate     =   "21 Feb 2010 19:05:15";
    intSeq      =   123;
    myDateTime =   str2datetime(strDate,intSeq);
    info(strFmt("datetime in GMT:       %1",datetime2str(myDateTime)));

    myDateTime =   DateTimeUtil::applyTimeZoneOffset(myDateTime,myTimeZone);
    info(strFmt("datetime in GMT+8:     %1",datetime2str(myDateTime)));

    //myDateTime =   str2datetime(strDate,intSeq);
    gmtDateTime =   DateTimeUtil::removeTimeZoneOffset(myDateTime,myTimeZone);
    info(strFmt("datetime in GMT:       %1",datetime2str(gmtDateTime)));
}

Was this reply helpful? Yes No
AdnDalhi 336 on at

Like (0)

Report
Copy link

Link copied!

Hi junior AX,

Please refere to this 2 links, you will find your answer:

String format options for UtcDateTime:

dev.goshoom.net/.../

Working with utcDateTime Functionality in Dynamics AX 2012 :

stoneridgesoftware.com/.../

Was this reply helpful? Yes No