Week number of year

[Totto]

Hi,
Is it possible to get number of the week from a DateTime type ?

Tnx
Totto

[Cor]

Hi Totto,

Have a look at this

http://msdn.microsoft.com/library/de...fyeartopic.asp

Cor

Hi,
Is it possible to get number of the week from a DateTime type ?

Tnx
Totto

[Philip Rieck]

DateTime.DayOfWeek is an enum. using
CInt(DateTime.DayOfWeek) will give you its numeric representation.

If you mean "week 12 of the year", then you need to do the calc yourself:
DateDiff(DateInterval.WeekOfYear, DateTime.Now, New
DateTime(DateTime.Now.Year, 1, 1))

You probably want to add one to that so that Jan1 is on the "first" week,
instead of the "zeroth" week
Also note the "FirstDayOfWeek" and "FirstWeekOfYear" optional parameters.

"Totto" <ta*********@norcon.no> wrote in message
news:uy**************@TK2MSFTNGP12.phx.gbl...

Hi,
Is it possible to get number of the week from a DateTime type ?

Tnx
Totto

[Armin Zingler]

"Totto" <ta*********@norcon.no> schrieb

Hi,
Is it possible to get number of the week from a DateTime type ?

MsgBox(DatePart(DateInterval.WeekOfYear, Date.Today, FirstDayOfWeek.System,
FirstWeekOfYear.System))
--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html