Re: Excel data transfer add-in DATE fields

["Mail List" <maillist@xxxxxxxxxxxxxxx>]

Hi Elvis,

Thanks, that's perfect!  Just one *minor* problem now -- some of the data in
these numeric fields do not a valid date make.  Besides the usual zero date
to indicate no value, there are some that are just plain wrong.  I can
handle the zero date problem with a CASE clause, but is there a way to trap
invalid dates?

Dave, thanks for the suggestion, but I was looking for a date result, not a
numeric result.

Peter Dow
Dow Software Services, Inc.
909 793-9050 voice
909 793-4480 fax
909 522-3214 cell

From: "Elvis Budimlic"
> Select cast(rtrim(char(MONTH)) || '/' || rtrim(char(DAY)) || '/' ||
> rtrim(char(YEAR)) AS DATE) as DateFld from Lib/File