TransferText macro

[bugsy]

Hey

I did a Macro with TransferText Action
Its transferring query (type - Export Delimited) to csv file

On a csv file when its created date fields have 12:00 00 am next to them, which is ruining a format.
If I change a table the query is based to thave them as text, the format is text instead of 'date' on the resulting file, and it won't download where it needs to

Anyone faced cimilar issue ?

 

[DJkarl]

This is because Access stores dates and Date/Time. If no time is entered then 12:00:00 AM is assumed. Try using the format function in your query for this field Format([YourField],"mm/dd/yyyy"), that should get rid of the time stamp.

 

[bugsy]

thanks !! added to your reputation