Julian Date Displayed in Form

  • Thread starter Thread starter George
  • Start date Start date
G

George

I would like to create a field on my form to display the current Julian date,
can somone walk me thru it - the novice version..

Thanks
 
George said:
I would like to create a field on my form to display the current Julian
date,
can somone walk me thru it - the novice version..
Click to expand...


You'd better define what you mean by Julian date. There's a specific
technical meaning for that term, but when most people refer to Julian date,
they just mean the date formatted as year and day of the year.

If that's what you mean, you could add a text box on your form and set its
ControlSource property to this expression, or some variation on it:

=Year(Date()) & "." & Format(Format(Date(),"d"),"000")
 
Dirk - I am using it for the Air National Guard - I tried your expression and
the response in the text field is 2008.012

George
 
George said:
Dirk - I am using it for the Air National Guard - I tried your expression
and
the response in the text field is 2008.012
Click to expand...


Sorry, I made a mistake in the expression. It should have been:

=Year(Date()) & "." & Format(Format(Date(),"y"),"000")

Does that give you what you're looking for?
 
Dirk - Thanks that works.

One last question what would be the expression if I just wanted
the three digit date - don't need the preceeding year ?

Thanks
 
Back
Top