>>You're welcome. One note about saying stores milliseconds. Actually not storing it as milliseconds but it's a real number keeping time as a fraction (terminology differs but result is same technically).
>>Cetin
>
>As a mather of fact, it IS stored in a millisecond format in the DBF. When it is used in memory it is in an floating-point format, giving rise to some rounding artifacts.
>
>(for the complete specs of how it is written to disk see my message in the newsgroup microsoft.public.fox.vfp.dbc on 22 jun 2003)
On dbf:
BINTOC(VAL(SYS(11,someDatatetime)),"RS"),BINTOC(Daymsec(someDatatetime),"RS")
On memory:
floatvalue=VAL(SYS(11,someDatatetime))+DaySec/86400
The problems are born because 1/86400 cannot be represented in base2.
Only datetimes with DaySec=k*675 they are exactly stored on memory.