What is the best way to convert a utcDateTime value to a date type so I can use the global datetime functions on it?
int timeDiff;
date _now = systemdateget();
;
select firstOnly myUTCDateTime from _myTable
timeDiff = Global::yearDiff(_now, _myTable.myUTCDateTime);
info(strfmt('%1', timeDiff);
Thanks
Logic for utcdatetime :
utcdateTime testDonedateTime1;
utcdateTime testDonedateTime;
transdate tmpDate ;
timeofday tmpTime;
testDonedateTime1 = inventJournalTable.PostedDateTime;
testDonedateTime = DateTimeUtil::applyTimeZoneOffset(testDonedateTime1, DateTimeUtil::getUserPreferredTimeZone())
tmpDate = DateTimeUtil::date(testDonedateTime);
tmpTime = DateTimeUtil::time(testDonedateTime);
Important : utcDateTime control properties TimeZonePreference set No conversion
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With