convert to julian date

Does anyone know how to convert a regular calendar date, i.e. 07/15/2004, into a julian date?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

What do you mean by Julian date? Many people have varying definitions.
For me a Julian calendar starts in January 1, 4713 BCE (Before Christian
Era). This calendar was named after Julius Scaliger (astronomer) not
Julius Caesar.

See this site for the conversion formulas for the astronomical Julian
date:

http://scienceworld.wolfram.com/astr...ulianDate.html

--
MGFoster:::mgf00 at earthlink decimal-point net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQPcmvIechKqOuFEgEQKLBgCgltwsIHQaRapX2sWBDFfQCt 3Njt0An0yJ
0o1d/LgghJPd3BGnn6fS3xmN
=IsW0
-----END PGP SIGNATURE-----


holmeb wrote:

Does anyone know how to convert a regular calendar date, i.e. 07/15/2004, into a julian date?

If what you mean is the day number of the date, assuming that 1 Jan = 1,
then the following should work if used in a query.

JulianDate = DateDiff("d", DateSerial(Year([What day?]) - 1, 12, 31), [What
day?])

What this does is calculate the number of days between the date you enter
and the 31st of December of the previous year

HTH
Dale

"holmeb" wrote in message
...
Does anyone know how to convert a regular calendar date, i.e. 07/15/2004,
into a julian date?

One method for YYDDD is

Format(SomeDate,"YY") & Format(DatePart("y",SomeDate),"000")

If you mean something else by JULIAN Date then please specify what your format
for Julian date is.

holmeb wrote:

Does anyone know how to convert a regular calendar date, i.e. 07/15/2004, into a julian date?

Thanks. It works.
--
bonnie


"John Spencer (MVP)" wrote:

One method for YYDDD is

Format(SomeDate,"YY") & Format(DatePart("y",SomeDate),"000")

If you mean something else by JULIAN Date then please specify what your format
for Julian date is.

holmeb wrote:

Does anyone know how to convert a regular calendar date, i.e. 07/15/2004, into a julian date?