Thread: C# основной форум/Correct date intervals for reports and SQL server queries

Correct date intervals for reports and SQL server queries

 


        public static DateTime FormatAsStartDateTime(DateTime startDate)

        {

            return new DateTime(startDate.Year, startDate.Month, startDate.Day);

        }

 

        public static DateTime FormatAsEndDateTime(DateTime endDate)

        {

            return new DateTime(endDate.Year, endDate.Month, endDate.Day) + TimeSpan.FromDays(1) - TimeSpan.FromMilliseconds(1);

        }