1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| Dim DateB1 As Variant, DateC1 As Variant, DateB2 As Variant, DateC2 As Variant
Dim DateMTP As Variant, DateRC As Variant
DateB1 = Me.DATE_D_EFFET_droit_de_base.Value
DateC1 = Me.DATE_D_EFFET_droit_complémentaire.Value
DateB2 = Me.NouvelleDateEffetDB.Value
DateC2 = Me.NouvelleDateEffetDC.Value
DateMTP = Me.DateEffetMTP.Value
DateRC = Me.DateEffetRC.Value
If Not IsNull(DateB1) Then
DateB1 = DateSerial(Year([DATE D'EFFET droit de base]), Month([DATE D'EFFET droit de base]), 1)
Else
End If
If Not IsNull(DateC1) Then
DateC1 = DateSerial(Year([DATE D'EFFET droit complémentaire]), Month([DATE D'EFFET droit complémentaire]), 1)
Else
End If
If Not IsNull(DateB2) Then
DateB2 = DateSerial(Year([NouvelleDateEffetDB]), Month([NouvelleDateEffetDB]), 1)
Else
End If
If Not IsNull(DateC2) Then
DateC2 = DateSerial(Year([NouvelleDateEffetDC]), Month([NouvelleDateEffetDC]), 1)
Else
End If
If Not IsNull(DateMTP) Then
DateMTP = DateSerial(Year([DateEffetMTP]), Month([DateEffetMTP]), 1)
Else
End If
If Not IsNull(DateRC) Then
DateRC = DateSerial(Year([DateEffetMTP]), Month([DateEffetMTP]), 1)
Else
End If
End Sub |
Partager