[RESOLVED] Date format in flexgrid from mdb

[IndraG]

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....

[jcis]

Did you try format(date, "dd-mmm-yy")?

[IndraG]

Yes, it works, thank you! Actually I tried it earlier but it did not work before, maybe because of wrong typo or something.

[jcis]

No prob, and Welcome to the forums
Remember to select "Mark thread Resolved" in the thread menu