I think it should be format("HH:mm)

the uppercase HH represents 24 hour time.
the lowercase hh represents 12 hour time.

Peter

I have encountered a problem when querying a table.
The query passed data into a recordset which should have resulted in many records but has returned EOF.

After debugging the code the only solution i have found is that i have set the recordset to NEW ADODB.RECORDSET two times before actually perfoming the rs.open (once in the main program and once in the dll which contains the loadrecords function).

MAIN PROGRAM...