Click here to Skip to main content
15,907,910 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Frames withVB.net Pin
Dave Kreskowiak22-Feb-07 9:23
mveDave Kreskowiak22-Feb-07 9:23 
Questionformat date Pin
jds120722-Feb-07 7:52
jds120722-Feb-07 7:52 
AnswerRe: format date Pin
alexfromto22-Feb-07 7:58
alexfromto22-Feb-07 7:58 
AnswerRe: format date Pin
alexfromto22-Feb-07 8:14
alexfromto22-Feb-07 8:14 
GeneralRe: format date Pin
Marcus J. Smith22-Feb-07 8:19
professionalMarcus J. Smith22-Feb-07 8:19 
GeneralRe: format date Pin
alexfromto22-Feb-07 8:22
alexfromto22-Feb-07 8:22 
GeneralRe: format date Pin
Marcus J. Smith22-Feb-07 9:04
professionalMarcus J. Smith22-Feb-07 9:04 
GeneralRe: format date Pin
jds120722-Feb-07 8:43
jds120722-Feb-07 8:43 
Is this code correct because I keep gettting the error:

Incorrect date value: '02/07/2006' for column 'OrderDate' at row 1

Here is code:

Dim dtTable As New DataTable
Dim row As DataRow
Dim formatdate As New DateTime

For Each row In dtTable.Rows
If row("datereceived").ToString() = formatdate.ToString("MM/DD/YYYY") Then
formatdate.ToString("YYYY-MM-DD")
ElseIf row("backorderdate").ToString() = formatdate.ToString("MM/DD/YYYY") Then
formatdate.ToString("YYYY-MM-DD")
ElseIf row("datecanceled").ToString() = formatdate.ToString("MM/DD/YYYY") Then
formatdate.ToString("YYYY-MM-DD")
ElseIf row("orderdate").ToString() = formatdate.ToString("MM/DD/YYYY") Then
formatdate.ToString("YYYY-MM-DD")
End If
Next row
GeneralRe: format date Pin
alexfromto22-Feb-07 8:53
alexfromto22-Feb-07 8:53 
AnswerRe: format date Pin
Dave Kreskowiak22-Feb-07 8:45
mveDave Kreskowiak22-Feb-07 8:45 
GeneralRe: format date Pin
alexfromto22-Feb-07 8:58
alexfromto22-Feb-07 8:58 
GeneralRe: format date Pin
jds120722-Feb-07 9:22
jds120722-Feb-07 9:22 
GeneralRe: format date Pin
Dave Kreskowiak22-Feb-07 9:27
mveDave Kreskowiak22-Feb-07 9:27 
GeneralRe: format date Pin
tonymathewt22-Feb-07 17:06
professionaltonymathewt22-Feb-07 17:06 
GeneralRe: format date Pin
Dave Kreskowiak23-Feb-07 2:08
mveDave Kreskowiak23-Feb-07 2:08 
QuestionExchange Pin
alexfromto22-Feb-07 7:27
alexfromto22-Feb-07 7:27 
AnswerRe: Exchange Pin
Dave Kreskowiak22-Feb-07 8:41
mveDave Kreskowiak22-Feb-07 8:41 
GeneralRe: Exchange Pin
alexfromto22-Feb-07 9:03
alexfromto22-Feb-07 9:03 
GeneralRe: Exchange Pin
Dave Kreskowiak22-Feb-07 9:22
mveDave Kreskowiak22-Feb-07 9:22 
GeneralRe: Exchange Pin
alexfromto22-Feb-07 9:30
alexfromto22-Feb-07 9:30 
GeneralRe: Exchange Pin
Dave Kreskowiak22-Feb-07 9:59
mveDave Kreskowiak22-Feb-07 9:59 
GeneralRe: Exchange Pin
alexfromto22-Feb-07 10:40
alexfromto22-Feb-07 10:40 
GeneralRe: Exchange Pin
Dave Kreskowiak22-Feb-07 11:57
mveDave Kreskowiak22-Feb-07 11:57 
QuestionDisplaying forms Pin
jady8422-Feb-07 7:17
jady8422-Feb-07 7:17 
AnswerRe: Displaying forms Pin
Dave Kreskowiak22-Feb-07 8:38
mveDave Kreskowiak22-Feb-07 8:38 

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.