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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use excel to calculate an expiration date 1
Julian Date Conversion 1
Strange Julian Date Phenomenon 10
VBA - exporting serial letters to single documents 0
Force date field update upon printing 0
Julian Date Question (Another) 4
How to add day to PWA 2016 date format? 0
Date Formats 4

Top