julian date conversion

V

vic

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

Douglas J. Steele

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)
 
Top