• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• SQLDate

SQLDate

Dates in SQl queries often cause problems, as the date must be in the ANSI format whereas dates brought back can be in a different local format. This function simply returns the date in the required format and save having to type Format(DateString, "mm/dd/yy") every time.

Inputs
The date to be processed as type DATE.

Assumes
Example SQl Query- SQL = "SELECT * from tblTest" SQL = SQL & " WHERE StartDate = #" & SQLDate(DateToConvert) & "#

Returns
A STRING containing the date formatted to the correct criteria.

API Declarations



Rate SQLDate

• 1
• 2
• 3
• 4
• 5

(4(4 Vote))

Public Function SQLDate(ConvertDate As Date) As String
  SQLDate = Format(ConvertDate, "mm/dd/yyyy")
End Function