Btrieve Date Integer

Question

here is my question:

I transfer data from a Btrieve file (.dat) through the Pervasive Control Center and there is a field type that is defined as an integer but is a date and, for example, the date 12/31/2009 (see the inherited system) is the number 733772 when I I export it.

The legacy system displays the date correctly, but I cannot export it in the same format, or at least I cannot convert it. Does anyone know how to convert this number through Excel or something like that?

Answer 1

When I divided 733772 into 365.2425 (the number of days in a year, given the Leap Year and the 29 days of February - http://www.timeanddate.com/date/leapyear.html ), it came back in 2009.

Answer 2

Go to the format cells and change the category to a date.