json Date format issue

umair mohsin

In my application i am returning data in json format .Date is returning from database too but not display what is saved in database.some in valid numbers are displaying i have no clue how to handle this thing.all data records are displaying accurate except date and i cannot show date in my textboxes which are of type input type=date

this is an update panel which is showing records from database i want the date selected and displayed from database, and in case user want to update date he/she could do so. can anybody help me please.

2 Replies

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

umair mohsin5y ago
date is returned from database.assume a database table column holding value.this value is passing from controller to view is json format. how may i apply
var json = config.Formatters.JsonFormatter;
json.SerializerSettings.DateTimeZoneHandling =Newtonsoft.Json.DateTimeZoneHandling.Local;
this to my value from database and show it in a textbox.
Rijwan Ansari5y ago
HI,

I think, you can format date while returning from api as shown:
DateTime.ParseExact(DateModel.ToString(), "dd/mm/yyyy", CultureInfo.CurrentCulture)
};
And also you can add datetimezone handling.
var json = config.Formatters.JsonFormatter;
json.SerializerSettings.DateTimeZoneHandling =Newtonsoft.Json.DateTimeZoneHandling.Local;