How to render DateTime in format DD/MM/YYYYTHH:mm ASP.NET CORE 5.0 MVC

Question

I am trying to render DateTime in format DD/MM/YYYYTHH:mm in C# ASP.NET CORE 5.0 MVC but I am not sure is it good idea to render in backend side or in frontend. Since in frontend side I use DataTable Currently this is format which I get in my datatable

2021-03-05T13:22:48.3190414

But I want to be formated as

05-03-2021T13:22

I try couple of solution something like in datatable

{
                "data": "dateAndTime", "width": "15%",
                "def": function () { return new Date(); },
                "displayFormat": 'DD/MM/YYYY',
                "wireFormat": 'YYYY-MM-DD',
                "keyInput": false
            },

 [Display(Name = "Datum i vrijeme slanja")]
        public DateTime DateAndTime { get; set; } = DateTime.Now;

Also in backend I try something like this:

ticketVM.Ticket.DateAndTime = DateTime.Parse("DD/MM/YYYY");

And get this kind of error

The string 'DD/MM/YYYY' was not recognized as a valid DateTime. There is an unknown word starting at index '0'.

Any advice and suggestion how to get format render in format DD/MM/YYYYTHH:mm ??

String '13/12/2021' was not recognized as a valid DateTime. — UnKnowUser
– UnKnowUser, Commented Mar 5, 2021 at 12:45
You need to parse the format that the string actually has. If you want to lose the millis: set them to 0. If you then want to display another format, you need to format the datetime value accordingly. DateTime itself has no format - it's just a number. — Fildor
– Fildor, Commented Mar 5, 2021 at 12:49
How to format DateTIme in format DD/MM/YYYYTHH:mm. You mean format in Model by using ` [DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:MM/dd/yyyy hh:mm}")]` — UnKnowUser
– UnKnowUser, Commented Mar 5, 2021 at 12:52
dotnetfiddle.net/gK6fTz , Your format is incorrect. See Custom date and time format strings. It needs to be "dd/MM/yyyyTHH:mm". — Fildor
– Fildor, Commented Mar 5, 2021 at 12:55

Fergus Liu · Accepted Answer · 2021-03-06 03:13:37Z

1

The Format String means it's a string after format:

public string DateAndTime()
{
    return DateTime.Now.ToString("dd/MM/yyyy HH:mm");
}

You can replace :

[Display(Name = "Datum i vrijeme slanja")]
public DateTime DateAndTime { get; set; } = DateTime.Now;

to

[Display(Name = "Datum i vrijeme slanja")]
public string DateAndTime { get; set; } = DateTime.Now.ToString("dd/MM/yyyy HH:mm");

About the ToString rules you can see Fildor's commets : See Custom date and time format strings .

edited Mar 6, 2021 at 3:13

answered Mar 5, 2021 at 13:07

Fergus Liu

394 bronze badges

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

3 Comments

UnKnowUser Over a year ago

Where to include this ? In Model or ... ?

Fergus Liu Over a year ago

You can replace : [Display(Name = "Datum i vrijeme slanja")] public DateTime DateAndTime { get; set; } = DateTime.Now; to [Display(Name = "Datum i vrijeme slanja")] public string DateAndTime { get; set; } = DateTime.Now.ToString("dd/MM/yyyy HH:mm"); About the tostring rules you can see Fildor's commets : See Custom date and time format strings .

UnKnowUser Over a year ago

Not sure how it is good idea to store day as String but however thank you for suggestion and you answer

Collectives™ on Stack Overflow

How to render DateTime in format DD/MM/YYYYTHH:mm ASP.NET CORE 5.0 MVC

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related