How to convert UTC into DateTime format

(0) Share

Report

Posted on by Samantha73

3,247

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)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

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,247 on at

Like (0)

Report

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,247 on at

Like (0)

Report

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,708 Moderator on at

Like (0)

Report

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

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November 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

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates