@flop said:
@garretro said:
It could be a Pick date. Pick stores date as an integer representing the number of days since 12/31/1967. If that is what you are seeing, I would urge caution when doing the conversion. I found in the past that Microsoft and D3 Pick disagree on the number of days between 12/31/1967 and today. At one point I figured out who was right, and where the difference came from, but that was YEARS ago.I think you mean the Lotus 1-2-3 compatibility in Excel and other products?
No, I meant Microsoft as a whole. Everything I tested at the time showed the same discrepancy. I checked several to make sure I wasn’t going crazy. I found the same difference in Excel, Access, VBA, VB6 and .Net (1.1).