Yes, I may have more than one purchase on the same day (and the field is smalldatetime).  I was able to take Farrell's post and make it work - thanks everyone...