How to get date from db to textbox

Question

Hi, I have tried so far is $('#txtAddedDate').val(data.d.AddedDate);. But its output will be /Date(1415212200000)/. I need it in 03/06/2014 format.

Anupam Singh · Answer

Hi Ranjith, try this : var curdate= $("#txtAddedDate").val(data.d.AddedDate); var datecheck=new Date(curdate); document.body.innerHTML = datecheck.getMonth() + '/' + datecheck.getDate() + '/' + datecheck.getFullYear(); //--> it should work.

Anupam Singh · Answer

Hmm.. try: var datecheck=new Date(document.getElementById("txtAddedDate").value); //this is your date document.body.innerHTML = datecheck.getMonth()+'/'+ datecheck.getDate()+ '/'+datecheck.getFullYear(); //--> put script this at last .And if you are getting value in txtAddedDate it will display correct format. best of luck !

Akhil Mittal · Answer

var datecheck=Convert.ToDateTime(data.d.AddedDate); $("#txtAddedDate").val((datecheck.Day ) + '/' + datecheck.Month + '/' + datecheck.Year))

Renjith V S · Answer

Hi Anupam Your answer is correct but I found an alternative it works me well. data.d.AddedDate is in json format. use this function to convert date $("#txtAddedDate").val(jsonDateformat(data.d.AddedDate)); function jsonDateformat(date) { jsonDate = date; var d = new Date(parseInt(jsonDate.substr(6))); var m, day; m = d.getMonth() + 1; if (m m = '0' + m if (d.getDate() day = '0' + d.getDate() else day = d.getDate(); var formattedDate = m + "/" + day + "/" + d.getFullYear(); var hours = (d.getHours() var minutes = (d.getMinutes() var formattedTime = hours + ":" + minutes + ":" + d.getSeconds(); formattedDate = formattedDate + " " + formattedTime; return formattedDate; }

Renjith V S · Answer

Hi Anupam, Still the same problem

Anupam Singh · Answer

Hi Ranjhit, Actually I tried this : var datecheck=new Date(1415212200000); //this is your date document.body.innerHTML = datecheck.getMonth()+'/'+ datecheck.getDate()+ '/'+datecheck.getFullYear(); //--> it means $("#txtAddedDate").val(data.d.AddedDate) has incorrect value.so you have to correct this. if you will try above code, will work fine.

Renjith V S · Answer

Hi anupam, I have tried your answer but the output is NaN/NaN/NaN

Renjith V S · Answer

no its not working

Anupam Singh · Answer

try using: var datecheck=data.d.AddedDate; $("#txtAddedDate").val((datecheck.getMonth() ) + '/' + datecheck.getDate() + '/' + datecheck.getFullYear())) not tested.

How to get date from db to textbox

Answers (9)