Posted on 2006-11-02
I have the below SQL Insert statement in my WinApp and I would like to make the formatting (mm/dd/yyyy) instead of the default mm/dd/yyy hh:mm
I am trying to do this an easy way without having to create a declaration first, because i know I can do it like so:
Dim strdate As DateTime
strdate = System.DateTime.Now
Dim displayString As String
displayString = Format(strdate, "MM/dd/yyyy")
strSQLInsert = strSQLInsert & "'" & Trim(System.DateTime.Now) & "',"