Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Excel Null Dates

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel Null Dates

    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

  • #2
    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


    • #3
      Excel Null Dates

      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.

      Comment

      Working...
      X