If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I get the date to display a Julian date? (yyddd)
I am trying to get the date to show up as a Julian date, yyddd. In my form
and report I need to have both regular ddmmyyyy and yyddd fields. they are the same day so if there is an expression that I can use to convert the first date into the julian that would work as well. Thanks |
#2
|
|||
|
|||
How do I get the date to display a Julian date? (yyddd)
next time try a simple search for it on this site...
this was given by Karl Dewey Format(Date(), "yy") & Format(DatePart("y", Date()), "000") "Jacobs33Ladder" wrote: I am trying to get the date to show up as a Julian date, yyddd. In my form and report I need to have both regular ddmmyyyy and yyddd fields. they are the same day so if there is an expression that I can use to convert the first date into the julian that would work as well. Thanks |
#3
|
|||
|
|||
How do I get the date to display a Julian date? (yyddd)
Jacobs33Ladder wrote:
I am trying to get the date to show up as a Julian date, yyddd. In my form and report I need to have both regular ddmmyyyy and yyddd fields. they are the same day so if there is an expression that I can use to convert the first date into the julian that would work as well. Thanks Being pedantic, but that is not a Julian date. I know a lot of IS people call it that. See http://en.wikipedia.org/wiki/Julian_day Mike |
Thread Tools | |
Display Modes | |
|
|