General information
Category:
Coding, syntax & commands
>>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
Hmmm...How about you come and do my work for me<bg>? Yes, indeed I have a rogue value in my data.
Thanks
Paul
Previous
Next
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