Exporting date to a text file

[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 .

 

[John Nurick]

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")

 

[Gals]

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

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 .

 

[John Nurick]

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

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 .

 

[Gals]

No No I need it without the " "

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

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 .

 

[John Nurick]

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 " "

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 .