vba:tutorials:sqldate
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
vba:tutorials:sqldate [21.09.2016 16:31:12] yaslaw |
vba:tutorials:sqldate [21.09.2016 16:32:04] (current) yaslaw |
||
|---|---|---|---|
| Line 17: | Line 17: | ||
| | Zeit | <code>#HH:NN:SS#</code> | <code>#13:06:54#</code> | <code>\#HH:NN:SS\#</code> | <code>"[myField] = " & format(myDateVar, \#HH:NN:SS\#)</code> | | | Zeit | <code>#HH:NN:SS#</code> | <code>#13:06:54#</code> | <code>\#HH:NN:SS\#</code> | <code>"[myField] = " & format(myDateVar, \#HH:NN:SS\#)</code> | | ||
| | Datum + Zeit | <code>#MM/DD/YYYY HH:NN:SS#</code> | <code>#09/21/2016 13:06:54#</code> | <code>\#\/MM\/DD\/YYYY HH:NN:SS\#</code> | <code>"[myField] = " & format(myDateVar, \#\/MM\/DD\/YYYY HH:NN:SS\#)</code> | | | Datum + Zeit | <code>#MM/DD/YYYY HH:NN:SS#</code> | <code>#09/21/2016 13:06:54#</code> | <code>\#\/MM\/DD\/YYYY HH:NN:SS\#</code> | <code>"[myField] = " & format(myDateVar, \#\/MM\/DD\/YYYY HH:NN:SS\#)</code> | | ||
| + | |||
| + | Siehe auch http://www.office-loesung.de/p/viewtopic.php?f=167&t=723793#p3003777 | ||
vba/tutorials/sqldate.1474468272.txt.gz · Last modified: 21.09.2016 16:31:12 by yaslaw
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
