1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Dim StrDateTime As String
StrDateTime = "20180711121027070" ' pour la date 11/07/2018 12:10:27.070
Dim LaDate As Date
Dim Lheure As Date
Dim Ans As Integer
Dim Mois As Integer
Dim Jours As Integer
Dim Heure As Integer
Dim Minute As Integer
Dim Seconde As Integer
Ans = Left(StrDateTime, 4)
Mois = Mid(StrDateTime, 5, 2)
Jours = Mid(StrDateTime, 8, 2)
Heure = Mid(StrDateTime, 9, 2)
Minute = Mid(StrDateTime, 11, 2)
Seconde = Mid(StrDateTime, 13, 2)
LaDate = DateSerial(Ans, Mois, Jours) '11/07/2018
Lheure = TimeSerial(Heure, Minute, Seconde) '12:10:27 |
Partager