Hi Can anyone please check my code ?
I'm trying to get today's date from database
I tried many ways and I'm stuck now..
at my database access
the transdate appears like this
11/29/2009 2:02:23 AM
and this is my query code from VB.NET
"SELECT TransDate, Deposit, Withdrawal, TotalAmount FROM Transactions " & _ "Where UserID =" & AccID & " and TransDate = " & DateTime.Today() & " " & _ "ORDER BY TransID"
is there anything wrong ? I debug and I got the date correct but the data won't show up