>Hi,
> What is a simple way to convert a date given in date base plus days to the Date() format. For example, April 6, 1999 is 36254 using Jan 1, 1900 as a base date, and 36256 for VFP6 using Dec. 30, 1899 as a base date as used in (I think) PowerSoft products. How would you convert that to the short (or long) date format in VFP6? Would you have to convert everything to Julian first?
>Thanks in Advance,
>Chris
Chris,
If you know the seed date this is easy;
* Jan 1, 1900 seed date
ldSeed = {^1900/01/01}
?ldSeed + 36254 && giove 4/6/1999
* Dec 30, 1899 seed
ldSeed = {^1899/12/30}
?ldSeed + 36256 && give 4/6/1999