>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.
>
>Thanks in Advance!
This looks like a day count - how many days ellapsed since a specified date. Some spreadsheets, including Excel, store dates in this format.
? {^2004-12-28} - {^1899-12-30}
Gives the number of days you indicated. See if you get consistent results with other dates (always using the same date, 30-dec-1899, in the subtraction).
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)