convert current date to julian date

G

Guest

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.
 
G

Guest

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...
 

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

How do I get the date to display a Julian date? (yyddd) 2
Convert julian date 14
convert from julian date 3
How to convert 2007-001 this year and day to a normal date? 1
Julian Date Display in Query 3
Julian Date conversion 9
convert julian dates to calender dates 3
Calculating a Julian Date 7

Top