GetDBDate - Formatting a date as a DateSerial for Access [ All Languages » VB »  Date-Time] Total Hit ( 2903) Rate this article:     Poor     Excellent   Submit Your Question/Comment about this article Rating

Click here to copy the following block ' Format a date as a DateSerial for Access ' Example: Debug.Print GetDBDate(date) Public Function GetDBDate(sDate As String) As String   On Error GoTo ERROR_GetDBDate   Dim sTmp As String   If IsDate(sDate) = False Then    sTmp = sDate   Else    sTmp = "DateSerial(" & Year(sDate) & ", " & Month(sDate) & ", " & Day _      (sDate) & ")"   End If EXIT_GetDBDate:   GetDBDate = sTmp   Exit Function ERROR_GetDBDate:   sTmp = sDate   Resume EXIT_GetDBDate End Function

Related Article(s)

Submitted By : Nayan Patel  (Member Since : 5/26/2004 12:23:06 PM)
	Job Description : He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.
View all (893) submissions by this author  (Birth Date : 7/14/1981 )