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.
Add Feedback (view all)
Leave feedback
is published and produced by Matt Thommes - an independent publishing enthusiast, mobile blogger, content creator, informative writer, web developer from 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.
Similar Entries
- Find a person’s age in Excel (1474 recent visits)
- Excel: Naming Cells and Ranges (441 recent visits)
- Excel project: weekly calendar (1315 recent visits)
- Excel text manipulation rocks (1691 recent visits)
- Excel absolute cell reference (1069 recent visits)
- Outlook and Excel formatting - take it easy! (15 recent visits)
Stats
278 unique visits since August 2008
Recent Referrers (click)
- add date within SQl
- sql excel date function
- sql where date excel
- SQL to Excel date "'"
- http://matthom.com/archive/200
- sql full date
- date() in excel sql criteria
- sql excel format date
- sql excel date
- sql excel date
- date sql excel
- date sql excel
- excel to sql dates
- excel to sql dates
- excel sql date
- date function excel sql
- date function excel sql
- excel dates in sql
- sql date to excel
- full date sql