Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date problems
Message
From
21/07/2001 08:43:15
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
21/07/2001 07:58:22
Paul Robinshaw
Silkworm Technologies Limited
Macclesfield, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00533489
Message ID:
00533502
Views:
12
>Hi All,
>
>I'm selecting a minimum date from a table with:
>
>SELECT min(somedate) ;
> FROM sometable ;
> INTO somearray
>
>
>The result gives me {01/09/1900}. The result _should_ be {01/09/2000}, any ideas how I get round this?
>
>Regards
>
>Paul

Paul,
Are you sure you don't have 1/9/1900.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform