1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| Function DateLongue(ValeurDate As Date, Langue As String) As String
Dim JourSemaine As Integer
Dim Jour As String
Dim Mois As String
Dim MoisAnnee As Integer
Select Case Langue
Case "F"
DateLongue = "Bruxelles, le " & Format(ValeurDate, "dddd d mmmm yyyy")
Case "N"
JourSemaine = Weekday(ValeurDate, vbMonday)
MoisAnnee = Month(ValeurDate)
Jour = Split(" maandag , dinsdag , woensdag , donderdag , vriidag , zaterdag , zondag ", ",")(JourSemaine - 1)
Mois = Split(" januari , februari , maart , april , mei , juni , julius , augustus , september , october , november , december ", ",")(MoisAnnee - 1)
DateLongue = "Brussel, de" & Jour & Format(ValeurDate, "d") & Mois & Format(ValeurDate, "yyyy")
End Select
End Function |
Partager