does anyone know the script for converting julian date to 
a standard date format?  preferably dd/mm/yy.
thks

What's your definition of "Julian Date"? If you're referring to the
representation that has year and what day of the year it is (eg.: today's
2004-183), use DateAdd to add the number of days to Dec. 31st of the
previous year. You can figure out Dec. 31st of the previous year by using
DateSerial(WhatYear-1, 12, 31)



-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"vic" <anonymous@discussions.microsoft.com> wrote in message
news:2495d01c45fb7$4e660820$a301280a@phx.gbl...
> does anyone know the script for converting julian date to
> a standard date format?  preferably dd/mm/yy.
> thks