SUPINFO International University

SUPINFO Institute of Information Technology
Laboratoire Microsoft




Déterminer la semaine du mois où tombe une date

Accueil > Script > maintenance > Déterminer la semaine du mois où tombe une date

Déterminer la semaine du mois où tombe une date

Par Alexandre VILLOING, LABORATOIRE SUPINFO DES TECHNOLOGIES MICROSOFT
Publiée le 11/05/2005 vers 0h.

dtmTargetDate = #12/19/2005#

dtmDay = DatePart("d", dtmTargetDate)
dtmMonth = DatePart("m", dtmTargetDate)
dtmYear = DatePart("yyyy", dtmTargetDate)

dtmStartDate = dtmMonth & "/1/" & dtmYear
dtmStartDate = CDate(dtmStartDate)

intWeekday = Weekday(dtmStartDate)
intAddon = 8 - intWeekday

intWeek1 = intAddOn
intWeek2 = intWeek1 + 7
intWeek3 = intWeek2 + 7
intWeek4 = intWeek3 + 7
intWeek5 = intWeek4 + 7
intWeek6 = intWeek5 + 7

If dtmDay <= intWeek6 Then
strWeek = "Week 6"
End If

If dtmDay <= intWeek5 Then
strWeek = "Week 5"
End If

If dtmDay <= intWeek4 Then
strWeek = "Week 4"
End If

If dtmDay <= intWeek3 Then
strWeek = "Week 3"
End If

If dtmDay <= intWeek2 Then
strWeek = "Week 2"
End If

If dtmDay <= intWeek1 Then
strWeek = "Week 1"
End If

Wscript.Echo strWeek



Proposer un script

Notre avis :

Votre avis :

Réactions :
0

Votants :
3

Visites :
11053

1
2
3
4
5




Retrouvez ci-dessous les autres sections du Laboratoire Microsoft