display julian date on a form 1

[ocan]

i am looking for the code to display julian date on a form.

thanks.

 

[PHV]

Something like this ?
Format(Date(), "YYy")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[CajunCenturion]

There are several different interpretations as to what "julian date" actually means. What do you mean by julian date?

Good Luck
--------------
To get the most from your Tek-Tips experience, please read FAQ181-2886
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[ocan]

Thanks PHV,

I'm not very familiar with date codes. How could i get
(three digit date)(last 2 digits of year)? same thing you did but with the day# 1st. I appreciate your help.

 

[BobJacksonNCI]

Shazam, PHV!

Much better than Ultimate Software's (microsoft) example:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209922&Product=acc

ocan,
In case PHV is having coffee just now, try:
Format(Date(),"y") & Format(Date(), "YY")

And be sure to give PHV the credit!


HTH,
Bob

 

[ocan]

thank you so much PHV & Bob. That's exactly what I needed.

 

[BobJacksonNCI]

THIS JUST IN ... *** ... *** ... ***

ocan,

The following will return 1, 2 or 3 digit followed by 2
For example, entering my birth month and day, Jan 2nd in the form of 1/2/4 returns 204, not 00204
Format(Date(),"y") & Format(Date(), "YY")

If you need to always have 3 digits followed by 2, use:
Format(Format(#1/2/4#,"y"),"000") & Format(Date(), "YY")


HTH,
Bob

 

[ocan]

thanks bob-the 2nd code is the one that works best. perfect!