DateTime.Now.ToUniversalTime().ToString("MMddyyyy", CultureInfo.InvariantCulture)

Day Formatters

d – Represents the day of the month as a number from 1 through 31

dd – Represents the day of the month as a number from 01 through 31

ddd – Represents the abbreviated name of the day of the week

dddd – Represents the full name of the day of the week

Month Formatters

M – Represents the month as a number from 1 through 12

MM – Represents the month as a number from 01 through 12

MMM – Represents the abbreviated name of the month

MMMM -Represents the full name of the month

Year Formatters

y – Represents the year as a one or two-digit number

yy – Represents the year as a two-digit number

yyy – Represents the year with a minimum of three digits

yyyy – Represents the year as a four-digit number

yyyyy – Represents the year as a five-digit number

Hour Formatters

h – Represents the hour as a number from 1 through 12

hh – Represents the hour as a number from 01 through 12

H – Represents the hour as a number from 0 through 23

HH – Represents the hour as a number from 00 through 23

Minute Formatters

m – Represents the minute as a number from 0 through 59

mm – Represents the minute as a number from 00 through 59

Second Formatters

s – Represents the seconds as a number from 0 through 59

ss – Represents the seconds as a number from 00 through 59

Time of Day Formatters

t – Represents the first character of the AM/PM designator

tt – Represents the AM/PM designator

: – Represents the time separator

/ – Represents the date separator

To read an excel file (.xls or .xlsx) use the following code.

    private const string excelConnectionXls = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=HMMasterlist.xls;Extended Properties=Excel 8.0";    private const string excelConnectionXlsx = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Sample.xlsx;Extended Properties=Excel 12.0";

    private void LoadSourceDocument()
    {
      log.Append("Begin Loading Excel n");
      OleDbConnection oledbConn = new OleDbConnection(excelConnectionXls);
      try
      {
        // Open connection
        oledbConn.Open();
        // Create OleDbCommand object and select data from worksheet Sheet1
        OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]", oledbConn);
        // Create new OleDbDataAdapter
        OleDbDataAdapter oleda = new OleDbDataAdapter();
        oleda.SelectCommand = cmd;
        // Fill the DataSet from the data extracted from the worksheet.
        oleda.Fill(sourceDS, "Locations");
        log.Append("Excel file loaded successfully. n");
      }
      catch (Exception ex)
      {
        log.Append("Loading Excel Spreadsheet Failed, ex: " + ex.Message + "n");
      }
      finally
      {
        // Close connection
        oledbConn.Close();
      }
    }
    private void UpdateLogoNames()
    {
      foreach (DataRow row in sourceDS.Tables[0].Rows)
      {
        string affiliateId = CheckAffiliateIdLength(row[0].ToString());
        List locations =
          SCCRetailPortal.SW_Locations.Where(x => x.AffiliateId.Equals(affiliateId)).ToList();
        if (locations.Count == 1)
        {
          locations[0].LocationShortName = row[1].ToString();
          log.Append(string.Format("Location {0}:{1} successfully updated. n", locations[0].LocationId,
                                   locations[0].LocationName));
        }
        else
        {
          log.Append(string.Format("FAILURE: No Location Found {0}:{1}. n", row[0], row[1]));
        }
      }
      SCCRetailPortal.SubmitChanges();
    }