date/time

[mcfenn]

hello

I like to export a date/time colum without the time information in it. I am
using the Format ([dates];"dd.mm.yyyy"). The result is "07.10.2005". That is
only half good because I need the result without the quotation marks like
07.10.2005 without setting this in the export spezifications because I need
the quotations marks as text seperator there. How can I do this?

Thanks in advance

 

[Guest]

CVDate(Int([YourDateDate]))

The "INT" removes any decimal fraction from the date.

 

[Joseph Meehan]

hello

I like to export a date/time colum without the time information in
it. I am using the Format ([dates];"dd.mm.yyyy"). The result is
"07.10.2005". That is only half good because I need the result
without the quotation marks like 07.10.2005 without setting this in the
export spezifications because
I need the quotations marks as text seperator there. How can I do
this?
Thanks in advance

07.10.2005 is text, which is why it is that way. I am not sure you can
get what you want.

 

[Van T. Dinh]

Actually, the result of the Format() function is a Variant of String type
07.10.2005 WITHOUT double-quotes. The export process adds the double-quotes
using the "default" Export Spec.

AFAIK, you need to set the Export Spec to export Strings without
double-quotes ...

 

[Joseph Meehan]

Actually, the result of the Format() function is a Variant of String
type 07.10.2005 WITHOUT double-quotes. The export process adds the
double-quotes using the "default" Export Spec.

AFAIK, you need to set the Export Spec to export Strings without
double-quotes ...

But can you do that for a single field?

" I need the result without the quotation marks like 07.10.2005 without
setting this in the export spezifications because I need the quotations
marks as text seperator there."

hello

I like to export a date/time colum without the time information in
it. I am using the Format ([dates];"dd.mm.yyyy"). The result is
"07.10.2005". That is only half good because I need the result
without the quotation marks like 07.10.2005 without setting this in
the export spezifications because I need the quotations marks as
text seperator there. How can I do this?

Thanks in advance

 

[mcfenn]

This is the problem. You cant do it in a single field!
I need datefield without question marks ans textfield wit question mark

Any other idea?

 

[Rick Brandt]

This is the problem. You cant do it in a single field!
I need datefield without question marks ans textfield wit question
mark
Any other idea?

AFAIK there is no DateTime "type" in any format of a text file. It is either a
number or it is a string (with quotes around it). Any handling of DateTime I
have ever seen in a text file has always had quotes around it. It is up to the
receiving program to know which strings are dates and which are text.