PDA

View Full Version : Changing Date Format in an array



mferrisi
04-19-2007, 07:00 AM
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
04-19-2007, 09:14 AM
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