How to convert date? [Answered]RSS

• • Reply
  Rejentt

  Member

  14 Points

  40 Posts

  How to convert date?

  Jan 27, 2015 05:38 PM|Rejentt|LINK

  Hello! I would like to convert my date which i got from events from Fullcalendar. Date looks like "2015-01-28T11:30:00.000Z". I wrote Json method which get my reqest.

  public JsonResult GetReservation(int doctor, string date)
          {
              RegisterVisitModel model = new RegisterVisitModel();
              model.doctor = DoctorRepository.GetDoctorByID(doctor);
              model.dateVisit = DateTime.ParseExact(date, "yyyy-MM-dd HH:mm:ss,fff", null); 
  
              return Json(new
              {
                  redirectUrl = Url.Action("WypelnijFormularz", "Dentist",model),
                  isRedirect = true
              });
          }

  here its error An exception of type 'System.FormatException' occurred in mscorlib.dll but was not handled in user code
  
  How can i parse string date to Datetime type? or how can i get string date without letter T and Z??

  Greetingss!

  C Json asp fullcalendar

• • Reply
  gerrylowry

  Star

  14297 Points

  5797 Posts

  Re: How to convert date?

  Jan 27, 2015 05:53 PM|gerrylowry|LINK

  @Rejentt

  String rejenttDateTime = "2015-01-28T11:30:00.000Z";
  Console.WriteLine (rejenttDateTime.Substring(0,10) );
  Console.WriteLine (rejenttDateTime.Substring(11, 12));
  DateTime parsedDateTIme = DateTime.Parse(rejenttDateTime.Substring(0,10) + " " + rejenttDateTime.Substring(11, 12));
  Console.WriteLine (parsedDateTIme);

  2015-01-28
  11:30:00.000
  2015-01-28 11:30:00

  
  
  

  C Json asp fullcalendar

  B-)  Gerry Lowry, Chief Training Architect, Paradigm Mentors Learning never ends... +1 705-999-9195 wasaga beach, ontario canada TIMTOWTDI =.there is more than one way to do it
• • Reply
  oned_gk

  All-Star

  52172 Points

  15482 Posts

  Re: How to convert date?

  Jan 27, 2015 07:19 PM|oned_gk|LINK

  Try this

  model.dateVisit = DateTime.ParseExact(date, "o", null); 

  model.dateVisit = DateTime.ParseExact(date, "u", null); 

  or

  model.dateVisit = DateTime.ParseExact(date, "yyyy-MM-ddTHH:mm:ss.000Z", null); 

  https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.boundfield.dataformatstring(v=vs.110).aspx

  C Json asp fullcalendar

  Programming to simplify, don't look for difficult way
  Suwandi - Non Graduate Programmer