Changing the date formats

Dear All,

I am getting two types of dates from a query to table CRMD_ORDERADM_H. One is of type DATS and other is of type DEC with char length 15.

Now I am exporting these two dates to a excel file where i want to display it into dd.mm.yyyy format.

How can I achieve this?

Regards,

Amey Mogare