1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| Private Sub Command1_Click()
Dim ladate As String
ladate = "31/12/2001" 'on part d'une française
MsgBox trans(ladate, "dd/mm/yyyy", "mm/dd/yyyy")
MsgBox trans(ladate, "dd/mm/yyyy", "yyyy/mm/dd")
ladate = "11/30/1999" ' on part d'une anglaise
MsgBox trans(ladate, "mm/dd/yyyy", "dd/mm/yyyy")
MsgBox trans(ladate, "mm/dd/yyyy", "yyyy/mm/dd")
ladate = "1998/03/08" 'on part d'une américaine
MsgBox trans(ladate, "yyyy/mm/dd", "dd/mm/yyyy")
MsgBox trans(ladate, "yyyy/mm/dd", "mm/dd/yyyy")
End Sub
Private Function trans(ld As String, format_entree As String, format_sortie As String) As String
If format_entree = "dd/mm/yyyy" Then
jour = 1: mois = 4: annee = 7
ElseIf format_entree = "mm/dd/yyyy" Then
jour = 4: mois = 1: annee = 7
ElseIf format_entree = "yyyy/mm/dd" Then
jour = 9: mois = 6: annee = 1
End If
trans = Format(DateSerial(Val(Mid(ld, annee)), Val(Mid(ld, mois)), Val(Mid(ld, jour))), format_sortie)
End Function |
Partager