G
Guest
On the query grid for a date field I can hardcode #5/7/2006# but find that
using #may/7/2006# is more reliable as it's specific and unambiguous, ie is
it May 7 or July 5 that I want. Does the local machine setting do the
determination when using the #5/7/2006# format? Is my #may/7/2006# solution
commonly used?
Also, I believe that I must use the #...# to indicate a date, true? When I
use the between [date1] and [date2] construct as a user prompt must I use ##
somehow?
Thanks.
using #may/7/2006# is more reliable as it's specific and unambiguous, ie is
it May 7 or July 5 that I want. Does the local machine setting do the
determination when using the #5/7/2006# format? Is my #may/7/2006# solution
commonly used?
Also, I believe that I must use the #...# to indicate a date, true? When I
use the between [date1] and [date2] construct as a user prompt must I use ##
somehow?
Thanks.