date calculation program

Hi

One of my vendor based tool is giving date in
no. of days since 1900-01-01.

 So, I want to display in CCYYMMDD format.

For ex:- Vendor based tool is giving as 38790 days since 1900-01-01
corresponding to12/sep/2006

Does anybody has the code for this conversion.

Thanks

Have you searched the site like the rules ask you to? Search for date calculation or date arithmetic and you will find the stuff that you want.