2,953
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
If its working then great.
I guess the solution is rather simple
to convert UTC string to datetime:
EVALUATE(MyDateTimeVar, UTCtext2)
Thanks but the problem is extracting DateTime or time from UTC as it's text
format(CurrentDateTime,0,9)
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
#1
Sohail Ahmed
2,655
#2
Mansi Soni
1,574
#3
YUN ZHU
1,453
Super User 2025 Season 1
Share
Report
All responses (
Answers (
