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

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


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

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


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
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date