convert current date to julian date

C

cougarky

I am trying to convert the current date "Now()" into a julian date (yyddd) in
a query field.
 
J

John Spencer

I get the following in the debug window.

Format(#01/09/2005#,"yy")& Format(Format(#01/09/2005#,"y"),"000") gives me
05009

Daycount comes back as one, two, or three digits depending on where you are
in the year. This has to be a string and not a number - unless you don't
mind loosing the leading zeroes.
 
C

cougarky

Thanks for your help.

John Spencer said:
I get the following in the debug window.

Format(#01/09/2005#,"yy")& Format(Format(#01/09/2005#,"y"),"000") gives me
05009

Daycount comes back as one, two, or three digits depending on where you are
in the year. This has to be a string and not a number - unless you don't
mind loosing the leading zeroes.
Click to expand...
 
Top