Problem Exporting time

[Guest]

I am exporting a "Short Time" (15:00) to a .CSV file. It comes out
"12/30/1899 15:00". I know why this is happening. But, How can I get it to
export as "15:00"?

 

[Guest]

Hi Jeff,

Explicitly format it using the format function, like this:

format(YOURFIELD, "HH:nn")

Hope that helps.

Damian.

 

[Guest]

couldn't you use the format function to extract on the time...

format(datetimevariablename,"hh:mm")

Daniel

 

[James A. Fortune]

I am exporting a "Short Time" (15:00) to a .CSV file. It comes out
"12/30/1899 15:00". I know why this is happening. But, How can I get it to
export as "15:00"?

Greetings Jeff Mc!

Use a query based on the table. For example,

SELECT TID, Format(tblTransactions.TransactionDate, 'Short Time') AS
TransactionDate, Amount FROM tblTransactions;

Save the query, then export the query rather than the table.

James A. Fortune
(e-mail address removed)