Thursday, 27 June 2013

Datetime format in Access

 DateTime TodayDate = System.DateTime.Today.Date;

 DateTime DATE1 = Convert.ToDateTime(dateTimePicker1.Text.ToString());
 string StartDate = objCommon.ReturnDate(DATE1);
 DateTime DATE2 = Convert.ToDateTime(dateTimePicker2.Text.ToString());
 string EndDate = objCommon.ReturnDate(DATE2);



  public string ReturnDate(DateTime datetoCompare)
        {
            string NewDate = datetoCompare.ToString();
            string[] NewDateArray = NewDate.Split('/');
            int date = Convert.ToInt32(NewDateArray[0].ToString());
            if (date > 12)
            {
                NewDate = datetoCompare.ToString("dd/MM/yyyy");
            }
            else
            {
                NewDate = datetoCompare.ToString("MM/dd/yyyy");
            }
            return NewDate;
        }

No comments:

Post a Comment