>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.
>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?
Ed
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only