Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Apr 8, 1999

Week of the Year

Question:
How can i find out the week number of the year in Visual Basic?

Answer:
This is easy to do using the DateDiff function. The DateDiff function can calculate the number of time intervals between two different intervals. You can look at the help file for all the constants, but the function can calculate the number of days, hours, minutes, etc. between two date values. In this case, we want to count the number of weeks between the selected date and January 1st of the year. To do this, you use this code:

   Dim intWeekNum As Integer
   intWeekNum = DateDiff("ww", #1/1/1999#, Date)
   intWeekNum = intWeekNum + 1
You have to add 1 to the week number because the DateDiff function counts the number of Sundays between the two dates. If you plugged in 1/2/1999 for the second date value, you would end up with zero since no Sundays elapsed between 1/1 and 1/2. Adding one corrects the problem.
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date