between date to date in vba(syntax)

[boblarson]

i've read (not sure) that since we use the day/month/year format here in the UI i still need to code my dates month/day/year *US format* - DateSerial returns (to my surprise) day/month/year (my local format) i wonder if 2007 is now smart enough to run both code and UI on same date settings?

with dateserial it works for both.