Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Axapta: Convert utcDateTime to date

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

like image 879
Brad Avatar asked Sep 02 '25 17:09

Brad


1 Answers

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

like image 70
Arpan Sen Avatar answered Sep 05 '25 07:09

Arpan Sen