Advertisement
6_2008-2009 Databases/ Data Access/ DAO/ ADO #195082

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.

AI

AI Samenvatting: This codebase represents a historical implementation of the logic described in the metadata. Our preservation engine analyzes the structure to provide context for modern developers.

Broncode
original-source
Public Function SQLDate(ConvertDate As Date) As String
  SQLDate = Format(ConvertDate, "mm/dd/yyyy")
End Function
Upload
Originele reacties (3)
Hersteld van de Wayback Machine