SQL Statement Requesting Data in a Certain Format from a MSAccess .mdb into a VB Application
Posted on 2003-03-08
I am using VB6.0 with WIN2000 and a MSAccess .mdb as a container for the data. I normally use the following statement in a SQL statement to request a date in a "mm/dd/yy" format from the SQL Server:
select convert(varchar(8), DatePurchased, 1) as DatePurchased from tbl_customers
The above code works fine when requesting information from the server. But when I use this code to request information from a MSAccess .mdb, I get error that "convert" is an undefined function.
Is there a way to order dates in a certain format (or style) from the MS Access .mdb?