convert current date to julian date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to convert the current date "Now()" into a julian date (yyddd) in
a query field.
 
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.
 
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
Moon phases and julian dates 0
convert from julian date 3
Convert julian date 14
convert Julian date to mm/dd/yyyy 4
convert julian dates to calender dates 3
How to convert 2007-001 this year and day to a normal date? 1
Calculating a Julian Date 7

Back
Top