Full date to SQL date within Excel Jan21 '05

Peter dropped some great feedback yesterday, regarding Excel date format issues.

His solution works, and it makes things a lot easier to convert full dates (Friday, January 21, 2005) to SQL dates (2005–01–21), within Excel.

Using the functions Peter provided, and then formatting the columns to a custom date format (yyyy–mm–dd), SQL dates are the result.

I like referencing feedback sometimes, because I am grateful for those who lend it. Often times it solves annoying problems, where I can’t find the answer elsewhere.

Categories: Software , SQL

Add Feedback (view all)

Leave feedback

Feedback

Input format: The editor controls below will assist with Markdown syntax.

Status

Sub-status

Your info

matthom is published and produced by Matt Thommes - an independent publishing enthusiast, mobile blogger, content creator, informative writer, web developer from a suburb of Chicago. Never one to conform, Matt intends to promote the effect the web has on our lives, in an effort to intensify, instruct, and clarify all that is happening around us.

Contact Matt

Popular Pages

  1. Fast rounded corners in Photoshop (4153 recent visits)
  2. PHP – passing variables across pages (1559 recent visits)
  3. JavaScript set selected on load (1290 recent visits)
  4. Removing all child nodes from an element (882 recent visits)
  5. iPod songs out of order? (747 recent visits)
  6. Britney - Everytime piano tab (669 recent visits)
  7. Firefox 3 smart address bar: wildcard search (633 recent visits)
  8. MySQL LEFT JOIN syntax (543 recent visits)
  9. Breathe Me - Sia (508 recent visits)
  10. Tumblr: how blogging should be (404 recent visits)

Similar Entries

Stats

36 unique visits since August 2008

Syndicate

Advertisements