How to convert UTC into DateTime format

(0) Share

Report

Posted on by Samantha73

3,328

Hi All

I want to add a number of minutes(hrs) to UTC and then extract the time part. Since UTC is converted to text, I cannot use DT2Time function.

here's what I have tried:

get date time as string

UTC := format(CurrentDateTime,0,9)

UTCText2 := Format(CurrentDateTime+ (MyMinutes*60000)),0,9);//add minutes to UTC

Now I'm stuck trying to extract Time part as DT2Time doesn't work on a string. Is there a way to get the UTC as a DateTime value or convert string to datetime?

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

You can try below

Hours, Minutes, Seconds and Millisecond are integer.

Milliseconds := TIME - 000000000T;

Hours := Milliseconds DIV 1000 DIV 60 DIV 60;

Milliseconds -= Hours * 1000 * 60 * 60;

Minutes := Milliseconds DIV 1000 DIV 60;

Milliseconds -= Minutes * 1000 * 60;

Seconds := Milliseconds DIV 1000;

Milliseconds -= Seconds * 1000;

MESSAGE('%1 %2 %3', Hours, Minutes, Milliseconds);

Source : forum.mibuso.com/.../how-to-calculate-hour-minutes-and-seconds-from-a-time

Was this reply helpful? Yes No
Samantha73 3,328 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks but the problem is extracting DateTime or time from UTC as it's text

format(CurrentDateTime,0,9)

Was this reply helpful? Yes No
Samantha73 3,328 on at

Like
a
(0)

Report
Copy link

Link copied!

I guess the solution is rather simple

to convert UTC string to datetime:

EVALUATE(MyDateTimeVar, UTCtext2)

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

If its working then great.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to convert UTC into DateTime format

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

How to convert UTC into DateTime format

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates