C# How to format Date ( DateTime) [duplicate]

Question

I need to get "Models.date_time" and execute "Foreach" for different days

Models.date_time {
2020-04-19 14:55:44

2020-04-19 16:55:44

2020-04-20 8:55:44

2020-04-19 12:55:44 }

foreach (var TransactionsModelsSaleDate in Models.Select(x => X.date_time.ToShortDateString()).Distinct()) {

DateTime TestUtcBeginDate = DateTime.ParseExact(TransactionsModelsSaleDate, "yyyy/MM/dd/00/00", System.Globalization.CultureInfo.CurrentCulture);
DateTime  BeginDate = ...............
DateTime  EndDate   = ...............

                    }

But I need to format "TransactionsModelsSaleDate" to get BeginDate , EndDate.

TransactionsModelsSaleDate {


2020-04-19

2020-04-20  }


But I also need to get this information

BeginDate  => 

2020-04-19 AM 12:00 00 

2020-04-20 AM 12:00 00 


EndDate    =>

2020-04-19  23:59 00

2020-04-20  23:59 00

How can I do?

Thanke so much!!

I'm finding it very hard to understand your question. You've dumped a bunch of data in here, but with no explanation of what type it is, what you're trying to achieve etc. Please read codeblog.jonskeet.uk/2010/08/29/writing-the-perfect-question — Jon Skeet
– Jon Skeet, Commented Apr 21, 2020 at 7:02
In addition to what Jon wrote, You should know that DateTime have no format. In .Net, It is stored as the number of ticks since January 1st, 0001 at midnight. — Zohar Peled
– Zohar Peled, Commented Apr 21, 2020 at 7:08

Radik · Accepted Answer · 2020-04-21 07:16:36Z

1

if you need list of dates you can select date part form DateTime

var list = Models.Select(x => X.date_time.Date).Distinct();

foreach (var TransactionsModelsSaleDate in list) {
}

answered Apr 21, 2020 at 7:16

Radik

2,7931 gold badge23 silver badges26 bronze badges

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

3 Comments

JunJia Huang Over a year ago

This is the method I need!

JunJia Huang Over a year ago

But I need to convert (2020-04-19) date to 2020-04-19-00-00

Radik Over a year ago

you can use custom format as DateTime.Now.ToString("yyyy-MM-dd-HH-mm") learn.microsoft.com/en-us/dotnet/standard/base-types/…

Collectives™ on Stack Overflow

C# How to format Date ( DateTime) [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related