[AccessD] TimeSerial buggy for negative date values

On 24 Apr 2006 at 7:25, Stuart McLachlan wrote:

> On 23 Apr 2006 at 16:29, Gustav Brock wrote:
> 
> > Hi all
> > 
> > Did you know that for Access up to and including version 2003 return wrong
> > date/time values when the parameters will result in a negative value?
> 
> Not wrong values, just values that you are not expecting. It's not a bug,
> it's a feature and it is in fact a feature of all calendars, it's not a
> microsoft thing. 
> 

I should have also said:
The date part of the value returned by Timeserial is unspecified. You 
should not rely on it:

<quote>
TimeSerial Returns a Variant (Date) containing the time for a specific 
hour, minute, and second.
</quote>

-- 
Stuart