export access date format to excel

[Guest]

In excel i have column that has a series of dates ie: 12/3/2004. 4/8/2006,...
I would like to have the dates changed to Jan 1 and the actual year, so
12/3/2004 will now be 1/1/2004. I read in a previous post that excel does not
keep the same formatting as excel so I guess a formula will be needed....

 

[Douglas J. Steele]

Are you saying that you want all of the dates changed to Jan 1 of whatever
year the date says? Why not just export the Year then?

Either way, you're going to need a query, with a computed field replacing
the date field. To have it as Jan 1, use DateSerial(Year(MyDateField), 1, 1)
as the calculation, for only the year, use Year(MyDateField).

 

[Guest]

I took over a report that has a pivot table in it that only reads the date in
a certain format like 1/1/2005, i havent really gone in and broken it down to
see how to correct it but thats what it needs to be to pull the information
and pivot the information correctly.