Export screws up date format even in one table database

[Guest]

Hi

I have re-written this question with further information about my test data
please don't dismiss it as being previously answered because it wasn't

I am having trouble with the transfertext acexportdelim function.

I have written several routines that export queries with date fields. I
have put format statements in the download queries as so that the data
is exported as dd/mm/yy.

Every time i run this it exports the dates as dd/mm/yy nn:hh:ss i
really don't understand why.

I built a brand new database with one table called Dates, and one field
named Birthdays

I created an export spec for this table and a qry in which i wrote the
following syntax

Birthdays: format([Dates].[Birthdays],"dd/mm/yy")

I then put one record in the table, ran the export and low and behold
the export still reads 01/01/01 00:00:00

I really don't understand how this is happening.

Thanks for any help in advance.

Gillian

 

[Joan Wild]

I cannot reproduce. I have repeated your steps exactly and the resulting
file has
"01/01/01"
in it.

What if you don't specify the export spec in your TransferText statement?

 

[Guest]

Hi

I tried it without the export spec and it works perfectly.

The problem is i really need the spec because the exports are not standard
csv exports, i need the fields seperated with the ~ character.

Do you know if there is any way i can work around this?

Thanks

Gillian

I cannot reproduce. I have repeated your steps exactly and the resulting
file has
"01/01/01"
in it.

What if you don't specify the export spec in your TransferText statement?

Hi

I have re-written this question with further information about my test
data
please don't dismiss it as being previously answered because it wasn't

I am having trouble with the transfertext acexportdelim function.

I have written several routines that export queries with date fields. I
have put format statements in the download queries as so that the data
is exported as dd/mm/yy.

Every time i run this it exports the dates as dd/mm/yy nn:hh:ss i
really don't understand why.

I built a brand new database with one table called Dates, and one field
named Birthdays

I created an export spec for this table and a qry in which i wrote the
following syntax

Birthdays: format([Dates].[Birthdays],"dd/mm/yy")

I then put one record in the table, ran the export and low and behold
the export still reads 01/01/01 00:00:00

I really don't understand how this is happening.

Thanks for any help in advance.

Gillian

 

[Rick Brandt]

Hi

I tried it without the export spec and it works perfectly.

The problem is i really need the spec because the exports are not standard
csv exports, i need the fields seperated with the ~ character.

Do you know if there is any way i can work around this?

In your export spec is that field defined as text or date? It needs to be text.

 

[Guest]

Hi

I had defined the fields as date/time fields.

When i change them to text fields the data exports perfectly.

Thanks very much for the help!

Gillian