Julian Date Displayed in Form

[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

 

[Dirk Goldgar]

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

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")

 

[George]

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

 

[Dirk Goldgar]

Dirk - I am using it for the Air National Guard - I tried your expression
and
the response in the text field is 2008.012

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?

 

[George]

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

 

[Douglas J. Steele]

=Format(Format(Date(),"y"),"000")