Help with Date Format

Giganews Newsgroups
Subject: Help with Date Format
Posted by:  hervinder
Date: Tue, 16 May 2006

I need help with data that i have exported from a database.

The date column is in a format i havent seen before

6093  Basically the "6" is for 2006, "093" is 93 days since the first of Jan.

Can someone please help me use the date function to get this into dd/mm/yy

Thanks in advance