Exporting date to a text file

  • Thread starter Thread starter Gals
  • Start date Start date
G

Gals

I'm trying to export a text file frome a query using :
" DoCmd.TransferText acExportDelim "
I hava a problem with a short date fileld thet comes out with the trime :
dd\mm\yyyy 00:00:00 - I need only the date part without
the time .
 
Hi Gals,

Use a calculated field in your query to format the date the way you
want, e.g.

MyDate: Format([TheDate], "dd/mm/yy")
 
Thenk you but now it comes like
"dd/mm/yyyy" i need it without the " " like thate
dd/mm/yyyy
Thenk's again

??"John Nurick said:
Hi Gals,

Use a calculated field in your query to format the date the way you
want, e.g.

MyDate: Format([TheDate], "dd/mm/yy")

I'm trying to export a text file frome a query using :
" DoCmd.TransferText acExportDelim "
I hava a problem with a short date fileld thet comes out with the trime :
dd\mm\yyyy 00:00:00 - I need only the date part without
the time .
Click to expand...
Click to expand...
 
One way round this is to export the file without adding the "..."
qualifiers. If they are really needed for the text fields, you can add
them in the query by using calculated fields like this
MyText: '"' & [TheText] & '"'



Thenk you but now it comes like
"dd/mm/yyyy" i need it without the " " like thate
dd/mm/yyyy
Thenk's again

??"John Nurick said:
Hi Gals,

Use a calculated field in your query to format the date the way you
want, e.g.

MyDate: Format([TheDate], "dd/mm/yy")

I'm trying to export a text file frome a query using :
" DoCmd.TransferText acExportDelim "
I hava a problem with a short date fileld thet comes out with the trime :
dd\mm\yyyy 00:00:00 - I need only the date part without
the time .
Click to expand...
Click to expand...
Click to expand...
 
No No I need it without the " "

??"John Nurick said:
One way round this is to export the file without adding the "..."
qualifiers. If they are really needed for the text fields, you can add
them in the query by using calculated fields like this
MyText: '"' & [TheText] & '"'



Thenk you but now it comes like
"dd/mm/yyyy" i need it without the " " like thate
dd/mm/yyyy
Thenk's again

??"John Nurick said:
Hi Gals,

Use a calculated field in your query to format the date the way you
want, e.g.

MyDate: Format([TheDate], "dd/mm/yy")


I'm trying to export a text file frome a query using :
" DoCmd.TransferText acExportDelim "
I hava a problem with a short date fileld thet comes out with the trime :
dd\mm\yyyy 00:00:00 - I need only the date part without
the time .
Click to expand...
Click to expand...
Click to expand...
 
What I meant was: that you should export the file without the "..."
qualifiers. TO do this, on the second page of the text export wizard,
select {None} from the Text Qualifier dropdown list.

But if you do this, none of the fields will have "..." qualifiers. If
you need to provide these for the text fields, you can do so by using
calculated fields in the query.


No No I need it without the " "

??"John Nurick said:
One way round this is to export the file without adding the "..."
qualifiers. If they are really needed for the text fields, you can add
them in the query by using calculated fields like this
MyText: '"' & [TheText] & '"'



Thenk you but now it comes like
"dd/mm/yyyy" i need it without the " " like thate
dd/mm/yyyy
Thenk's again

??"John Nurick" <[email protected]>
Hi Gals,

Use a calculated field in your query to format the date the way you
want, e.g.

MyDate: Format([TheDate], "dd/mm/yy")


I'm trying to export a text file frome a query using :
" DoCmd.TransferText acExportDelim "
I hava a problem with a short date fileld thet comes out with the trime :
dd\mm\yyyy 00:00:00 - I need only the date part without
the time .
Click to expand...
Click to expand...
Click to expand...
 
Back
Top