Changing Date Format in an array

[mferrisi]

The following query brings in dates, but in the m/dd/yyyy hh.mm.s format, and I want them to be in m/dd/yyyy.

How can I easily make this change inside of the array? Thanks!

querystring = "SELECT Performance.Date, Performance.Return FROM Performance ORDER BY Performance.Date;"
databaseName = DatabaseConnection
TempW = SQLRequest(databaseName, querystring, , 4, False)

[omocaig]

the solution will probably depend on what db you're querying if it's Access you can use the format function.

format(Performance.Date,'mm/dd/yyyy')

hth,
Giacomo