Export Date/Time data type question?

[acin0026]

I have two fields (MyDate and MyTime). Both are Date/Time data type. I need to export to text file. After I export, It have default value in the field MyDate and MyTime

Example
MyDate, MyTime
6/20/01,10:28

After I export, It shows
6/20/01 0:00:00, 12/30/99 10:28:00

Is there any way to export just MyDate and MyTime but not show default time in MyDate and default date in MyTime.

thanks.

 

[Ziggurat]

Hi

Try using
format(MyDate,"YYYY/MM/DD&quot for the date
and
format(MyTime,"HH:NN:SS&quot for the time

*
***
*****
*******
Ziggurat

 

[Aivars]

...or

format(MyDate,"YYYY/MM/DD HH:MM:SS&quot' for the date

Aivars

 

[Aivars]

I'm sorry, I was unobservant. I ditn't right.
Aivars