Mike Faust wrote:<BR>
> Has anyone found a reasonable solution to the issue of transferring<BR>
> date field values into Excel using Client Access data transfer.<BR>
> Currently all dates transferred in appear as Text. They can be<BR>
> converted to date values fairly easily but *LOVAL dates (01-01-0001)<BR>
> are also no recognized be Excel as the lowest valid date in Excel is<BR>
> 01-00-1900.<BR>
<P>
Mike,<BR>
<P>
Couldn't you just use a Case statement to handle the *Loval condition?<BR>
<P>
Bill<BR>
<P>
<P>

Has anyone found a reasonable solution to the issue of transferring date field values into Excel using Client Access data transfer. Currently all dates transferred in appear as Text. They can be converted to date values fairly easily but *LOVAL dates (01-01-0001) are also no recognized be Excel as the lowest valid date in Excel is 01-00-1900.

Yes, But I'm looking for a solution for customers who don't want to have to modify existing data transfers which worked in earlier versions when these fields were defined as numeric dates.