Query problem using "last" (3 Viewers)

[arnelgp]

Why do you think that Access and Excel have different date references for day 0 of their internal calendar?

just tested it both, in Excel VBA and Access VBA:

format(cdate(0),"mm/dd/yyyy")

they both return:

12/30/1899