export access date format to excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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....
 
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).
 
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.
 
Back
Top