One method is to create a query in Access 2K using the query
builder to format a new column with the time / date format
that you want. For instance, this is from the SQL view of a
query named qryAccess2k:
SELECT [table].[Date], Format([table].[date],"mm-dd-yyyy") AS
formatted
FROM table
Then from your script, substitute the table name with the
query / view name:
SELECT Date, formatted
FROM qryAccess2k
Note that if you are sorting, sort on the table.Date field
and not the formatted field since the formatted field will
return a straight alphabetic sort order.
-Jim
[EMAIL PROTECTED] wrote:
> I would like to know if there is a way to get rid of the
> time info. that I get when a
> fetch an Access2K database. What I am getting now is
> "2000-08-21 00:00:00", I
> would like to have "08-21-2000" only and not the 00 time.
> Any ideas, suggestions are welcome.
> Thanks,
> Mas
