DMAX returns a value smaller than DMIN!

[junker1234]

Hi

With the help of several of the members of this group I think I finally
got my database working!

The only issue is that I have DMAX and DMIN functions to compute the
most distant expected and soonest expected arrival times for items on a
particular invoice.

This works great about 95% of the time. However, the other 5% of the
time the DMAX value is lower than the DMIN value. This isn't a huge
deal but I'm a little curious about how this is possible.

Here are the DMIN and DMAX functions and their parameters:

GroupMin: DMin("[FinalExp]","rebuild","[InvNumber] ='" & Sales.Num &
"'")
GroupDate: DMax("[FinalExp]","rebuild","[InvNumber] ='" & Sales.Num &
"'")

Given that they share the same criteria isn't it impossible that a DMAX
is lower than a DMIN?

Thanks a lot for any insight

 

[Douglas J. Steele]

What's the data type of FinalExp? If it's text, then what format is it in?
If it's date, then I'd have to agree with you that it shouldn't be
happening.

 

[David Cox]

id DMAX gives 1/3/2006 and DMIN gives 3/1/2006 someone in the U.S.A. might
have a different view of the reliability from someone in the U.K.