Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
# of days since Jan. 1
3 views
Skip to first unread message
mate
Jul 16, 2004, 3:19:54 PM7/16/04
to
i want to use the number of days since Jan. 1 first in an
equation. Is there an expression to calculate this? any
help is greatly appreciated. Thankyou.
equation. Is there an expression to calculate this? any
help is greatly appreciated. Thankyou.
mate.
Rick B
Jul 16, 2004, 3:28:26 PM7/16/04
to
DaysPast: Date()-#01/01/04#
Will tell you the number of days between today and Jan 1.
Rick B
"mate" <anon...@discussions.microsoft.com> wrote in message
news:2db3801c46b69$dfb53770$a601...@phx.gbl...
John Spencer (MVP)
Jul 16, 2004, 8:58:55 PM7/16/04
to
For the current date of the current year, you can use the formula below.
DateDiff("d",DateSerial(Year(Date()),1,1),Date())
John Vinson
Jul 18, 2004, 6:57:16 PM7/18/04
to
One question, several solutions: yet another is
Format(Date(), "y")
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
0 new messages