Date Format

May 12, 2009 at 08:16:13
Specs: Windows XP
Hello,

I am using MS Excel 2003 and creating queries and I need to format the date to be a year only. Example: I have gdisc_action_date and it displays as 2007-08-14 00:00:00 and I need it to be 2007 only. Can you PLEASE help me??


See More: Date Format

Report •


#1
May 12, 2009 at 10:01:28
You will need a Custom Format

On the Task Bar,
Select Format
Select Cells
Select Custom (Bottom of List)
On the right side, Under the word "Type"
delete the word "General"
and add YYYY
Click OK
Your cell will now show only the Year.

Also, you will get a better response to Excel questions if you post your questions in the Office Software forum.

MIKE

http://www.skeptic.com/


Report •

#2
May 13, 2009 at 06:04:31
Thanks Mike!! And thinks for the tip on posting questions, I appreciate it!

Report •

#3
May 13, 2009 at 06:16:30
Mike, I left out that I am using SQL within Excel, to query not just Excel (which your instructions work for) but I'm trying to format the date in the SQL.

Tool bar select
Data/Import External Data/New Database Query

Its within this query I need to change the date to display the year only.


Report •

Related Solutions

#4
May 14, 2009 at 18:14:42
Sorry, my SQL knowledge is just above nil.

If you repost with the SQL requirement in the heading you might get a better response.

MIKE

http://www.skeptic.com/


Report •


Ask Question