To convert a timestamp in milliseconds to a date format like
2020-08-20T23:00:00Z in X++, you can use the DateTimeUtil class to convert the timestamp to a DateTime value, and then format it as needed. Here’s an example of how you might do it:static void ConvertTimestampToDate(Args _args)
{
// Your timestamp in milliseconds
int64 timestamp = 1716336000000;
// Convert the timestamp to DateTime
DateTime dateTime = DateTimeUtil::addMilliseconds(DateTimeUtil::utcNow(), timestamp - DateTimeUtil::getSystemDateTime());
// Convert DateTime to desired format
str formattedDate = DateTimeUtil::toStr(dateTime, DateTimeUtil::TimeZone::UTC);
// Print the formatted date
print formattedDate;
pause;
}
This code snippet assumes that the timestamp
1716336000000 is the number of milliseconds since the Unix epoch (January 1, 1970). The DateTimeUtil::addMilliseconds method is used to add the timestamp to the Unix epoch to get the correct DateTime. Then, DateTimeUtil::toStr is used to convert the DateTime to a string in the ISO 8601 format, which matches the format you provided (2020-08-20T23:00:00Z). Please adjust the logic if your timestamp is based on a different epoch or requires different handling.
