You would need to parse the date after the data is returned and then display it however you want.
If you want more specific information, you need to give us more. Things like how are you retrieving the date, (Btrieve vs SQL), what programming environment, and what you have tried.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.