Click here to Skip to main content
15,792,608 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: format date Pin
Marcus J. Smith23-Feb-07 9:44
professionalMarcus J. Smith23-Feb-07 9:44 
GeneralRe: format date Pin
jds120723-Feb-07 9:53
jds120723-Feb-07 9:53 
GeneralRe: format date Pin
Marcus J. Smith23-Feb-07 9:57
professionalMarcus J. Smith23-Feb-07 9:57 
AnswerRe: format date Pin
Marcus J. Smith23-Feb-07 10:01
professionalMarcus J. Smith23-Feb-07 10:01 
GeneralRe: format date Pin
jds120723-Feb-07 10:10
jds120723-Feb-07 10:10 
GeneralRe: format date Pin
Marcus J. Smith23-Feb-07 10:16
professionalMarcus J. Smith23-Feb-07 10:16 
GeneralRe: format date Pin
jds120723-Feb-07 10:19
jds120723-Feb-07 10:19 
GeneralRe: format date Pin
Marcus J. Smith23-Feb-07 10:26
professionalMarcus J. Smith23-Feb-07 10:26 
jds1207 wrote:
Dim MyCommand As New Odbc.OdbcCommand("INSERT INTO ls_orderitems (OrderDate, OrderCustomer, OrderAcctNum, OrderType, OrderSoNum, OrderItemPartNum, OrderItemPartDesc, OrderItemQty, OrderItemQtyRec, OrderItemQtyDtRec, OrderItemBO, OrderItemBODt,OrderItemCanceled, OrderItemCanceledDt, OrderItemNotes, OrderItemPONum, OrderItemRetailPrice, OrderItemSalePrice, Status, InsertDate) VALUES('" & CDate(OrderDate).ToString("yyyy-MM-dd") & "','" & OrderCustomer & "','" & OrderAcctNum & "','" & OrderType & "','" & OrderSoNum & "','" & OrderItemPartNum & "','" & OrderItemPartDesc & "','" & OrderItemQty & "','" & OrderItemQtyRec & "','" & CDate(OrderItemQtyDtRec).ToString("yyyy-MM-dd") & "','" & OrderItemBO & "','" & CDate(OrderItemBODt).ToString("yyyy-MM-dd") & "','" & OrderItemCanceled & "','" & CDate(OrderItemCanceledDt).ToString("yyyy-MM-dd") & "','" & OrderItemNotes & "','" & OrderItemPONum & "','" & OrderItemRetailPrice & "','" & OrderItemSalePrice & "','" & Status & "','" & InsertDate & "')")


The stuff in bold, just leave it as CDate(VariableName). Before you run this command do something like If OrderDate.Trim = "" Then OrderDate = DBNull.Value to insert a NULL value instead of trying to convert a blank value to a date.



CleAkO

GeneralRe: format date Pin
jds120723-Feb-07 10:53
jds120723-Feb-07 10:53 
GeneralRe: format date Pin
Marcus J. Smith23-Feb-07 11:04
professionalMarcus J. Smith23-Feb-07 11:04 
GeneralRe: format date Pin
Dave Kreskowiak23-Feb-07 11:27
mveDave Kreskowiak23-Feb-07 11:27 
QuestionCaret Size Pin
Anybloodyid23-Feb-07 8:54
Anybloodyid23-Feb-07 8:54 
AnswerRe: Caret Size Pin
Dave Kreskowiak23-Feb-07 11:25
mveDave Kreskowiak23-Feb-07 11:25 
AnswerRe: Caret Size [modified] Pin
TwoFaced23-Feb-07 12:32
TwoFaced23-Feb-07 12:32 
GeneralRe: Caret Size Pin
Dave Kreskowiak23-Feb-07 15:02
mveDave Kreskowiak23-Feb-07 15:02 
GeneralRe: Caret Size Pin
TwoFaced23-Feb-07 15:31
TwoFaced23-Feb-07 15:31 
GeneralRe: Caret Size Pin
Anybloodyid23-Feb-07 23:53
Anybloodyid23-Feb-07 23:53 
GeneralRe: Caret Size Pin
TwoFaced24-Feb-07 0:51
TwoFaced24-Feb-07 0:51 
GeneralRe: Caret Size Pin
Anybloodyid24-Feb-07 2:22
Anybloodyid24-Feb-07 2:22 
GeneralRe: Caret Size Pin
TwoFaced24-Feb-07 9:28
TwoFaced24-Feb-07 9:28 
GeneralRe: Caret Size Pin
Anybloodyid24-Feb-07 10:42
Anybloodyid24-Feb-07 10:42 
GeneralRe: Caret Size Pin
TwoFaced24-Feb-07 11:14
TwoFaced24-Feb-07 11:14 
GeneralRe: Caret Size Pin
Anybloodyid24-Feb-07 12:11
Anybloodyid24-Feb-07 12:11 
GeneralRe: Caret Size Pin
TwoFaced24-Feb-07 13:54
TwoFaced24-Feb-07 13:54 
GeneralRe: Caret Size Pin
Anybloodyid24-Feb-07 23:47
Anybloodyid24-Feb-07 23:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.