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/d...balizationcalendarclassgetweekofyeartopic.asp

Cor

 

[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.

 

[Armin Zingler]

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