How do I format a Microsoft JSON date?

Question

Aryan Kumar · Answer

Microsoft JSON dates are formatted as a string with the following format:

Code snippet

/Date(millisecondsSinceUnixEpoch)/

For example, the date 2023-05-15 00:00:00 UTC would be formatted as follows:

Code snippet

/Date(1652454400000)/

To format a Microsoft JSON date, you can use the following steps:

Get the date object.
Use the getTime() method to get the number of milliseconds since the Unix epoch.
Use the toUTCString() method to convert the number of milliseconds to a string in UTC format.
Surround the string with forward slashes (/).

Here is an example of how to format a Microsoft JSON date:

Code snippet

const date = new Date();
const jsonDate = `/Date(${date.getTime()})/`;

The jsonDate variable will now contain the date formatted in Microsoft JSON format.

You can also use the following function to format a Microsoft JSON date:

Code snippet

function formatMicrosoftJSONDate(date) {
  return `/Date(${date.getTime()})/`;
}

Here is an example of how to use the formatMicrosoftJSONDate() function:

Code snippet

const date = new Date();
const jsonDate = formatMicrosoftJSONDate(date);

The jsonDate variable will now contain the date formatted in Microsoft JSON format.

forum