Mike Faust wrote: > 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. Mike, Couldn't you just use a Case statement to handle the *Loval condition? Bill
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Excel Null Dates
Collapse
X
-
Excel Null Dates
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.
Comment