Date Retrieving Problem

I am retrieving data from database in MVC core using jquery Ajax. All the fields have successfully retrieved and work well but the datae fields cannot be retrieved. For date i used the date control i.e. . Please check only the following fields:

$("#dtpEmpBirthDate").val(response[i].EmpBirthDate);
$("#dtpEmpJoiningDate").val(response[i].EmpJoiningDate);

Please explain how to add the retrieved date value from the database into the date control. The above two date fields do not populate with the response object. Following is my complete code of jquery Ajax:

//Retrieve the Employee record using the selected Employee ID
$.ajax({
url: "/RetrieveData/RetrieveEmployeeRecordByID",
type: "GET",
dataType: "json",
data: { "id": empID },
success: function (response) {
for (var i = 0; i < response.length; i++) {
$("#txtEmployeeCode").val(response[i].EmpCode);
$("#txtEmpFirstName").val(response[i].EmpFirstName);
$("#txtEmpLastName").val(response[i].EmpLastName);
$("#txtEmpFullName").val(response[i].EmpFullName);
$("#dtpEmpBirthDate").val(response[i].EmpBirthDate);
$("#cmbEmpGender").val(response[i].EmpGender);
$("#txtEmpFullAddress").val(response[i].EmpFullAddress);
$("#dtpEmpJoiningDate").val(response[i].EmpJoiningDate);
$("#cmbEmpReligion").val(response[i].EmpReligion);
$("#txtEmpTelephoneNumber").val(response[i].EmpTelephoneNumber);
$("#txtEmpMobileNumber").val(response[i].EmpMobileNumber);
$("#txtEmpEmailAddress").val(response[i].EmpEmailAddress);
$("#cmbEmpBranchCode").val(response[i].EmpBranchCode);
$("#cmbEmpDepttCode").val(response[i].EmpDepttCode);
$("#cmbEmpOccupationCode").val(response[i].EmpOccupationCode);
$("#cmbEmpNationality").val(response[i].EmpNationality);
$("#cmbEmpMaritalStatus").val(response[i].EmpMaritalStatus);
$("#txtEmpDependent").val(response[i].EmpDependent);
$("#txtEmpEmergencyContact").val(response[i].EmpEmergencyContact);
$("#txtEmpEmergencyContactPerson").val(response[i].EmpEmergencyContactPerson);
$("#txtEmpEmergencyContactPersonRelation").val(response[i].EmpEmergencyContactPersonRelation);
$("#txtEmployeePictureFullPath").val(response[i].EmpPicture);
} //End of for Loop
},
error: function (response) {
alert("Record cannot be displayed", response.responseText);
}
});

The above Jquery Ajax successfully retrieves data from the database and all the fields are populated well but only the date fields cannot be populated. Please give me solution.

Following is the HTML code of the date fields:

class="col-md-3">
class="form-group">
for="EmpBirthDate" class="control-label label-size">Birth Date
"date" asp-for="EmpBirthDate" id="dtpEmpBirthDate" class="form-control textbox" />

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg7y ago
Try like this,
var empBirthDate=response[i].EmpBirthDate;
var formattedDate=empBirthDate.format('YYYY-MM-DD');
$("#dtpEmpBirthDate").val(formattedDate);
Thanks.
Adalat Khan7y ago
If possible please update my code only the date field. It will help me.
Salman Beg7y ago
For formatting you can try like this, var today = moment().format('YYYY-MM-DD'); $('#datePicker').val(today);
Adalat Khan7y ago
Dear Salman
The Date is comming in the response object because i displayed the retrieved date in a textbox then it is displayed but it does not display inside in the date control. when i display the date in a simple textbox then it is displayed but it does not display in the date control. I think this is formatting problem but i don't know how to formate the retrieved value according to the date control.
Salman Beg7y ago
Hi. Maybe data is not there in the date field. So what you can do is put debugger; in the success function and check whether data is coming or not in the date field. Thanks.