My thanks to you both for your help; this works perfectly!
>>I am converting some dbf's into Access tables and ran across a field that is being created in VB by performing clnt() on a date. Is there a way to duplicate this in VFP so I can populate this field?
>>
>>Example 12/28/2004 comes out to 38349.
>
>In Access, Excel and some other applications a date is represented as a serialized number with 1 been January 1, 1900.
lnSerNum = 38349
>? {^1899/12/30} + lnSerNum
Because of the bug in the original implementation (it considered year 1900 to be a leap year), the inital date to which serialized number gets added, is {^1899/12/30} instead of {^1899/12/31} .
Steve Howie, owner
DaSH Technology
Denver, CO