How do I get the date to display a Julian date? (yyddd)
in [General]
|
From: Jacobs33Ladder on 5 May 2010 02:42 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
From: Maarkr on 5 May 2010 07:19 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
From: MikeR on 5 May 2010 10:07 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
|
Pages: 1 Prev: 2 independent criteria in a query Next: Format problem using combo box |