In my database the dates are stored as doubles so they look like numbers so 37999 is really 13/01/2004.

I've been trying then format the number in a datagrid back to standard date, but have no luck.

Is ASP is was easy I just did X=Cdate(RS("MyDate")) and it was done, but I cannot get it to work in ASP.NET

Thanks for any help provided

I am so excited to be able to answer someone's question:

Date.FromOADate(37999).ToShortDateString will get you what you need!

At rathbird example will work and,
You can also use ToString() method:
for example your DateTime type variable dt, and string var x.
i. x= dt.ToString("dd/mm/yyyy") to gives 13/01/2004
ii. x= dt.ToString("dd-mmm-yyyy") to gives 13-Jan-2004
iii. x= dt.ToString("dd mmmm yyyy") to gives 13 January 2004 .. and so on

Kasie.