How do i...date comes to action and saves in SQL in format 1/1/0001 in .NET core 5

Question

0.00/5 (No votes)

See more:

I have a form to get StartDate and EndDate.

C#

[Display(Name = "StartDate")]
        [DataType(DataType.Date)]
        [DisplayFormat(DataFormatString = "{0: MM/dd/yyyy}",
            ApplyFormatInEditMode =true)]
        public System.DateTime StartDate { get; set; }

input is like this :

HTML

<pre><div class="form-group">
                        <label>End Date  </label>
                        <input  asp-for="Slider.EndDate"  name="EnDate"  id="enDate" required />
                    </div>

in code behind there is a property named Slide :

C#

<pre>  [BindProperty]
        public Carousel.DataLayer.Entities.Slider.Slider Slider { get; set; }

the value of comes to action method is : 1/1/0001 and it saves in sql like this

What I have tried:

I changed the format in class Slider several times and I added datepicker .

Posted 6-Oct-21 9:24am

ali mahdian

Updated 6-Oct-21 11:56am

v3

Add a Solution

Comments

PIEBALDconsult 6-Oct-21 15:46pm

Dates/times should not be stored as text, therefore not with any format.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2021-10-06T10:03:00

DateTime values (in both C# and SQL) aren't stored with a format - they are held as a number of "Ticks" since a defined moment in time.
The only way to hold a format with a date is to store it as a string, and that's a really poor idea (especially with a web based app) because the date format that users enter and expect to see will be different from user to user: the US uses MM/dd/yy, Europe uses dd/MM/yy, and Japan / developers use ISO format yy/MM/dd.
Storing it as a string is bad because at some point the wrong date format will be used and the whole of your DB data becomes suspect, or your queries fail as a result.

Forget date formats: validate and convert user input as early as possible (while you still have access to the user preferences), store it as a "proper" DateTime value, and only convert it back to a formatted string at the last moment when again you have access to teh new user preferences.

Doing at any other way is just building up problems for yourself, and your users. And some of them can take some serious sorting out once the DB starts to get corrupted "bad format" values.

ali mahdian · Answer 2 · 2021-10-06T11:56:00

HTML

<pre> <div class="form-group">
                        <label>End Date  </label>
                        <input  asp-for="Slider.EndDate" name="EndDate"  id="enDate" required />
                    </div>

I set attribute name for input ,while I'm using asp-for .I removed attribute name and now it works correctly.

How do i...date comes to action and saves in SQL in format 1/1/0001 in .NET core 5

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0