Data Report

I use VB 6 SP3. I want to generate a data report (with help of a data environment) and the problem is that I cannot find a way of formating the fields as I want. For example the field Date inside the database (SQL Server) has this shape: '1201' which represents that month=12 and day=01 (Today date), but I want to display it as '01/12/1999'. How can I make it possible? Have I to create views inside SQL Server in order to achieve it? or not?
Thanks,

Dr_Michael (cannot login anymore) :-(