Exporting time with date

[Guest]

Hi there. Using A02 on XP. Not a programmer but working to learn.

I have a Date/Time field in Access that I'm exporting out to a comma
delimited file (.csv) and my date fields are adding 0:00 to the date when I
export. I've checked my field properties and the table was created using a
macro to import an Excel file. Even if I format the Excel file before
importing, the .csv export inserts the 0:00 in my date fields when I export.

It should read: 09/29/1945
But it reads: 09/29/1945 0:00

Is there something I can do besides having to manually fix it after exporting?

Any help or advice would be greatly appreciated.

 

[John Nurick]

Hi Bonnie,

Create a query that returns the fields you want to export. Use a
calculated field in the query to format the date the way you want, e.g.
FixedDate: Format([TheDate], "mm/dd/yyyy")

Then export the query.

 

[Guest]

Thank you John. Sorry I didn't think of it myself. Format in the query. Duh!

I really appreciate the time you are taking to help me with this project.
--
Bonnie

Hi Bonnie,

Create a query that returns the fields you want to export. Use a
calculated field in the query to format the date the way you want, e.g.
FixedDate: Format([TheDate], "mm/dd/yyyy")

Then export the query.

Hi there. Using A02 on XP. Not a programmer but working to learn.

I have a Date/Time field in Access that I'm exporting out to a comma
delimited file (.csv) and my date fields are adding 0:00 to the date when I
export. I've checked my field properties and the table was created using a
macro to import an Excel file. Even if I format the Excel file before
importing, the .csv export inserts the 0:00 in my date fields when I export.

It should read: 09/29/1945
But it reads: 09/29/1945 0:00

Is there something I can do besides having to manually fix it after exporting?

Any help or advice would be greatly appreciated.