Hi Ed
>
>I've written a prog to work in FPD, to read in an XLS/CSV file and create a table (from a given copy struct).
>>
>>
>>When I run this, a date field that yields, say, 11/04/2006 in VFP, ends up with XX/XX/1920.
>>
>
>Terry, if it were a century problem, your date would read 11/04/1906.

Aye, but somehow the "20" of my long-date year is becoming the "20" of 1920, I assumed

>
>>I've got century on, date british
>>
>>The s/s/ date is in the form: XX-XX-2006
>>I've just realised that I haven't Set Mark to "-" - would that make any difference?
>>
>>Obviously, somewhere the s/w is treating the date as short (as with Cent off) but I can't figure out how/why.
>>
>>Any ideas?
>>
>
>Not sure it is a century thing... I tried a simple test:
>1. created a cursor with date field
>2. set date to british
>3. m.e="11-04-2006"
>4. replaced date with ctod(m.e)
>
>works fine...
>
>Could it be that you are browsing the data and it just "looks" like 11/04/20...i.e. a browse preference or browse last (originally century off)that only shows the first 2 digits of the year with century on?

Do I look that thick? (Don't answer that!)

No, it's defo "/1920"

Terry