Hi,
I retrieve a recordset from mdb file using ADO and SQL 'select... from...' and use it to populate a flexgrid. My problem is that I simply can't find a way to get the date format into a dd-mmm-yy format! Can anyone help, please? Converting the flexgrid after it is populated is simply not an option due to size and time. I have also looked for a date format function to be used in SQL statement in my SQL book, unfortunately it only listed function for Oracle which do not work in my environment. This may be the way to go, if I can find the right function.

Thank you....