date/time

M

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
 
K

KARL DEWEY

CVDate(Int([YourDateDate]))

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

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

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?
 
R

Rick Brandt

mcfenn said:
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?
Click to expand...

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