Date - potatoscript/csharp GitHub Wiki

home

■ Day of Week
■ DateTime.DayOfWeek for specific culture
■ Difference between two dates
■ First and Last Day of Month
■ Get Date

home

DayOfWeek

   var thisDay = (DateTime.Now.AddDays(-2).ToString("dd")).ToString();
   var thisMonth = (DateTime.Now.AddMonths(0).ToString("MM")).ToString();
   var thisYear = (DateTime.Now.AddYears(0).ToString("yyyy")).ToString();
   
   DayOfWeek day = DateTime.Now.AddDays(-2).DayOfWeek;
   if(day==DayOfWeek.Sunday)
   {
      // code block
   }

home

DateCulture

var culture = new System.Globalization.CultureInfo("ja");
char[] sp = {'-'};
var thedate = db.data[0][1].Split(sp,StringSplitOptions.RemoveEmptyEntries);
DateTime dateValue = new DateTime(int.Parse(thedate[0]), int.Parse(thedate[1]), int.Parse(thedate[2]) );
var day = culture.DateTimeFormat.GetDayName(dateValue.DayOfWeek);

home

DifferenceBetweenTwoDates

• Assuming StartDate and EndDate are of type DateTime:

(EndDate - StartDate).TotalDays

or

(EndDate - StartDate).Days

• Convert String to DateTime

CultureInfo culture = new CultureInfo("ja");
var nday = 0;
try
{
    char[] sp = { '-' };
    var sdate = StartDate.Split(sp, StringSplitOptions.RemoveEmptyEntries);
    var edate = EndDate.Split(sp, StringSplitOptions.RemoveEmptyEntries);

    DateTime startdate = Convert.ToDateTime(sdate[2]+"/"+sdate[1]+"/"+sdate[0]+" 12:10:15 PM", culture);
    DateTime enddate = Convert.ToDateTime(edate[2] + "/" + edate[1] + "/" + edate[0] + " 12:10:15 PM", culture);
    nday = (enddate - startdate).Days;
}
catch(Exception e) { }

home

FirstLastDayOfMonth

DateTime date = DateTime.Now;
var FirstDay = new DateTime(date.Year, date.Month,1);
var LastDay = FirstDay.AddMonths(1).AddDays(-1);

home

GetDate

• Example

  input_date = DateTime.Now.AddDays(0).ToSring("yyyy-MM-dd");
  DateTime date = DateTime.Now;
  var fDay = new DateTime(date.Year, date.Month, 1); // get the first day of the month
  var lDay = fDay.AddMonths(1).AddDays(-1); // get the last day of the month

• To set the custom format for the date you need to comment up //Application.EnableVisualStyles(); in Program.cs

private void Form1_Load(object sender, EventArgs e)
{
   inputDate.Format = DateTimePickerFormat.Custom;
   inputDate.CustomFormat = "yyyy-MM-dd";
   inputdate.Text = DateTime.Now.AddDays(0).ToString(); // output => today date
   inputdate.Text = DateTime.Now.AddDays(1).ToString(); // output => tomorrow date
}