ZMBD:
Second your date field in your table would accept #MM/DD/YYYY# by default from code. The only reason to format is for a text field
I'm not sure I would agree with that Z.
Even in the USA I would recommend that date values are
Format()
ed into the SQL string as it is only a coincidence that USA date formats are acceptable in a SQL string. Almost anywhere else in the world pushing the date value into the SQL string
without formatting it first will cause failures and unrequired results. yyyy-m-d is a particularly good way to format the date as it implicitly makes clear that the date is formatted for SQL rather than accidentally or randomly dropped in, and is fully internationally independent.
One addition I would advise for full portability (Some countries recognise the '-' as a date separator and convert it automatically to a '\' and thus
break the SQL string.) would be to
escape the '-' characters with the backslash. Thus the format used would be :
See
Literal DateTimes and Their Delimiters (#) for more on this.
NB. For the original question, it seems that
Now()
would be a good way to express the current Date/Time. It works in both SQL and VBA.
As for the rest of the question, I'm equally confused as to what you're asking.