Folks
I am using autofill to fill some fields based on selection of a particular drop down. One of the fields which are filled automatically is a date field, which is supposed to only DOB i.e.dd/mm/yyyy. But, during autofill the value that is retrieved is in dd/mm/yyyy hh:mm:ss, though in the backend ( SQL Server 2008 R2) the data is in dd/mm/yyyy format.
Can someone please explain why and how to overcome this ?
Thanks