Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Difference in Date Save between VPP 7 & FPD
Message
From
27/09/2006 02:59:08
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01157275
Message ID:
01157397
Views:
17
>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
Map
View

Click here to load this message in the networking platform