Monday 31 March 2014

Check Date formate and convert in datetime using c#

 string dd =lbldt.Text.Substring(0, lbldt.Text.Length - (lbldt.Text.Length - 2));
                    string [] pp = dd.Split('/');
                    if (Convert.ToInt32(pp[0]) < 12)
                    {
                        ldatet = Convert.ToDateTime(lbldt.Text, CultureInfo.InvariantCulture);
                    }
                    else
                    {
                        ldatet = Convert.ToDateTime(lbldt.Text, CultureInfo.CreateSpecificCulture("en-AU").DateTimeFormat);                  
                    }

Convert datetime dd/mm/yyyy to mm/dd/yyyy using c#

 string dt=  DateTime.ParseExact("28/08/2012", "dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("MM/dd/yyyy", CultureInfo.InvariantCulture);

//Converting DateTime
Convert.ToDateTime(lbldt.Text, CultureInfo.CreateSpecificCulture("en-AU").DateTimeFormat);

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...