I am returning the system date and time with NOW function and displaying it
in a text box. The user then saves the data to an Access 2000 database.
The field the date is being saved is a general date field. When the user
displays that same record in a MSHFlexGrid the date shows up in yyyy-dd-mm
24 hour time format. I am populating my MSHFlexGrid by DESC order on the
Date field with a recordset. Is there any way to format the Date field in
the SQL statement when returning the recordset? Or am I going in the wrong
direction?

Thanks

RE