Exporting Date Incorrectly

[jmeckley]

I have a simple routine I created in Access. Import a text file, export queried results of that file into seperate text files.

The user will enter a date in a text box provided on the form. The exported query will select 2 fields from the query a static field that is defined in the query and the date that was entered on the form.

The problem is the exported date is not a date at all, but a row of hexidecimal, or something close to it.

I have the query below and a sample of the text file.

Query:
SELECT Imported_Records.MemberID,
"Lap Tag" AS Title,
Imported_Records.LapTag AS Tag,
Forms!TargetTag_frm!txtDate AS [Date]
FROM Imported_Records
WHERE (((Imported_Records.LapTag) Is Not Null))
ORDER BY Imported_Records.MemberID;

Results:
"MemberID","Title","Tag","Date"
"00352965","Add Tag","H",31 00 32 00 2F 00 32 00 35 00 2F 00 31 00 39 00 38 00 30 00
"00352967","Add Tag","H",31 00 32 00 2F 00 32 00 35 00 2F 00 31 00 39 00 38 00 30 00
"00352968","Add Tag","H",31 00 32 00 2F 00 32 00 35 00 2F 00 31 00 39 00 38 00 30 00
"00352969","Add Tag","H",31 00 32 00 2F 00 32 00 35 00 2F 00 31 00 39 00 38 00 30 00
"00352970","Add Tag","D",31 00 32 00 2F 00 32 00 35 00 2F 00 31 00 39 00 38 00 30 00
"00352972","Add Tag","D",31 00 32 00 2F 00 32 00 35 00 2F 00 31 00 39 00 38 00 30 00
Thank you for your assistance

Jason Meckley
Database Analyst
WITF

 

[jmeckley]

I found a solution, although I don't think it is the best way to do it.

I created another column in the table that is updated to the value on the form when the information is imported. Then I export it.

Any ideas, why the date was exporting funky? Thank you for your assistance

Jason Meckley
Database Analyst
WITF