ASP.net Core 6 - How to convert serialized dates into DateTime?

Question

In my controller I have a httpget that requires the input of two dates (ideally without time, but should work either way).

 // GET: api/Shippingschedules/shipname
        [HttpGet("{startdate},{enddate}")]
        public async Task<ActionResult<Shippingschedule>> GetShippingSchedulesByDates(string startdate, string enddate)
        {
            CultureInfo ukCulture = new CultureInfo("en-GB");
            DateTime sDate = DateTime.Parse(startdate, ukCulture.DateTimeFormat);
            DateTime eDate = DateTime.Parse(enddate, ukCulture.DateTimeFormat);

            ActionResult<Shippingschedule> Shippingschedule = await _context.Shippingschedules.Where(
                x => x.StartDate >= sDate && x.EndDate <= eDate).FirstOrDefaultAsync();

            if (Shippingschedule == null)
            {
                return NotFound();
            }

            return Shippingschedule;
        }

When I debug into the sDate line, the program stops with error:

String '1%2F1%2F2022' was not recognized as a valid DateTime. at System.DateTime.Parse(String s, IFormatProvider provider)

How do I deserialise this into a real datetime object?

Thanks

@YiyiYou - anything in en-GB format such as 1/1/2022 or 31/1/2022 or 12-FEB-2022 23:45 or 10-MAR-2022 1:12:00 PM... all of those could be entered into the text field and should be convertable — Fandango68
– Fandango68, Commented Apr 13, 2022 at 23:21

Serge · Accepted Answer · 2022-04-13 12:11:13Z

1

try this

using System.Net;

 var startdateDecoded= WebUtility.UrlDecode(startdate);
var enddateDecoded= WebUtility.UrlDecode(enddate);

CultureInfo ukCulture = new CultureInfo("en-GB");
 DateTime sDate = DateTime.Parse(startdateDecoded, ukCulture.DateTimeFormat);

.....

answered Apr 13, 2022 at 12:11

Serge

44.4k4 gold badges26 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ASP.net Core 6 - How to convert serialized dates into DateTime?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related