Julian date

[George Sydney]

I am trying to add the julian date to my report. I want the program to take
the system date and convert it and display the julian date on the report.
Please can anyone help me?

 

[Douglas J. Steele]

Depends on what you mean by Julian Date.

If you're talking about the syntax where the date is represented as the day
of the year (i.e. today, 11 Dec, 2007 is day 345), you can simply use the
Format function (Format(Date, "y")) or DatePart function (DatePart("y",
Date)) (Note that the difference is Format returns a string, whereas
DatePart returns a number).

If you want to use 2007345 (or the less recommended 07345) to represent the
date, you'd use:

Format(Date, "yyyy") & Format(DatePart("y", Date), "000")

or

Format(Date, "yy") & Format(DatePart("y", Date), "000")

 

[George Sydney]

Thank you douglas.

I have inserted this into the control source of the text box of the report
im trying to create and when I run the report ms access prompts me for a date.
Can i possibly have the report automatically generate the julian date
without the prompt?

Would appreciate your help.

Thanks
--
George Sydney
Frustrated programmer

Depends on what you mean by Julian Date.

If you're talking about the syntax where the date is represented as the day
of the year (i.e. today, 11 Dec, 2007 is day 345), you can simply use the
Format function (Format(Date, "y")) or DatePart function (DatePart("y",
Date)) (Note that the difference is Format returns a string, whereas
DatePart returns a number).

If you want to use 2007345 (or the less recommended 07345) to represent the
date, you'd use:

Format(Date, "yyyy") & Format(DatePart("y", Date), "000")

or

Format(Date, "yy") & Format(DatePart("y", Date), "000")

 

[KARL DEWEY]

Post what you put in the text box.
--
KARL DEWEY
Build a little - Test a little

Thank you douglas.

I have inserted this into the control source of the text box of the report
im trying to create and when I run the report ms access prompts me for a date.
Can i possibly have the report automatically generate the julian date
without the prompt?

Would appreciate your help.

Thanks

 

[George Sydney]

I have inserted the following in the text box

Format(Date, "yy") & Format(DatePart("y", Date), "000")

This produces the julian date BUT the report first prompts you with a date,
once you enter a date the report displays the julian date.

What i would like is the program to instantly produce a julian date without
the need to enter the date manually.

Would appreciate any assistance.

Regards George

 

[KARL DEWEY]

Try this --
Format(Date(), "yy") & Format(DatePart("y", Date()), "000")