vba:tutorials:sqldate
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
vba:tutorials:sqldate [21.09.2016 16:24:56] yaslaw |
vba:tutorials:sqldate [21.09.2016 16:32:04] (current) yaslaw |
||
|---|---|---|---|
| Line 11: | Line 11: | ||
| ^ ^ Format ^ Beispiel ^ Formatstring für den format() Befehl ^ Anwendung ^ | ^ ^ Format ^ Beispiel ^ Formatstring für den format() Befehl ^ Anwendung ^ | ||
| - | | String | 'text' | 'Mein Text' | | "[myField] = '" & myStringVar & "'" | | + | | String | <code>'text'</code> | <code>'Mein Text'</code> | | <code>"[myField] = '" & myStringVar & "'"</code> | |
| - | | ::: | "text" | "Mein Text" | | "[myField] = """ & myStringVar & """" | | + | | ::: | <code>"text"</code> | <code>"Mein Text"</code> | | <code>"[myField] = """ & myStringVar & """"</code> | |
| - | | Zahl | 0.00 | 1234.56 | | "[myField] = " & myNumberVar | | + | | Zahl | <code>0.00</code> | <code>1234.56</code> | | <code>"[myField] = " & myNumberVar</code> | |
| - | | Datum | #MM/DD/YYYY# | #09/21/2016# | \#\/MM\/DD\/YYYY\# | "[myField] = " & format(myDateVar, "#\/MM\/DD\/YYYY\#") | | + | | Datum | <code>#MM/DD/YYYY#</code> | <code>#09/21/2016#</code> | <code>\#\/MM\/DD\/YYYY\#</code> | <code>"[myField] = " & format(myDateVar, "#\/MM\/DD\/YYYY\#")</code> | |
| - | | Zeit | #HH:NN:SS# | #13:06:54# | \#HH:NN:SS\# | "[myField] = " & format(myDateVar, \#HH:NN:SS\#) | | + | | 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 | #MM/DD/YYYY HH:NN:SS# | #09/21/2016 13:06:54# | \#\/MM\/DD\/YYYY HH:NN:SS\# | "[myField] = " & format(myDateVar, \#\/MM\/DD\/YYYY HH:NN:SS\#) | | + | | 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.1474467896.txt.gz · Last modified: 21.09.2016 16:24:56 by yaslaw
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
