Exporting dates to Excel from Access

[Guest]

When I export a table to Excel, I have a field that I want to populate with a
date that I put in through a pop up. However, when I open the Excel file-
all the data except the date has exported over. When I run it in Access,
(not exporting) it works fine.

Any Ideas?

 

[Wolfgang Kais]

Hello Gina.

When I export a table to Excel, I have a field that I want to populate
with a date that I put in through a pop up.

How is the popup generated?

However, when I open the Excel file-all the data except the date has
exported over. When I run it in Access, (not exporting) it works fine.

The tablè?
What about creating a query that contains a parameter of type Date/Time
(MyDate) whose value is contained in the select list ([MyDate])?
Define the parameter via the "query, parameters" menu command.
Then export the query instead of the table.

 

[Guest]

Awesome! Thank you very much. It worked wonderfully.
--
Gina

Hello Gina.

When I export a table to Excel, I have a field that I want to populate
with a date that I put in through a pop up.

How is the popup generated?

However, when I open the Excel file-all the data except the date has
exported over. When I run it in Access, (not exporting) it works fine.

The tablè?
What about creating a query that contains a parameter of type Date/Time
(MyDate) whose value is contained in the select list ([MyDate])?
Define the parameter via the "query, parameters" menu command.
Then export the query instead of the table.