Json Date Conversion

[#1]

Hi All,

I am getting a response of date in Json format /Date(253402300799000) which I want to show in as a normal date on my UI (dd/mm/yyyy). I have written a function to convert it but for certain scenarios it is failing like for date 9999-12-31 & 1900-01-01.

When I convert the above one it is giving me the date 1-1-10000 & 1-1-2040.

here is the function which I have Written :

for (var i = 0; i < oData.date.length; i++)

{

var oDate = oData.date[i].DATE.match(/\d+/g);

var oDate1 = new Date(parseInt(oDate));

var sDate = oDate1.getMonth() + 1 + "-" + oDate1.getDate() + "-" + oDate1.getFullYear();

oData.date[i].DATE = sDate;

}

Note : I am using xsoData.

[mvaibhav]

Hi Sandeep,

The issue is not with your code but seems like there is some internal conversion happening from the back-end when the date is being returned.

The value which is being returned ( /Date(253402300799000)) results to date as Jan 01 10000.

Are there any chances that those 2 dates would be returned from your back-end ? If no, then probably you can ignore these.

Else you need to handle these explicitly when you date object results in these kind of dates.

Thanks,

vaibhav