hi there,
on my form have fixed exp date "31 december" for year it will +1 year .
below is my current code
TempohMohon = textbox with number 1 --> 5. 1 equal to 1 year
TarikhMohon =current date
TarikhTamat = exp date with 31 december
so i want do this,
if TarikhMohon 1 january 2021 - 30 june 2021, with tempohmohon 1 year
tarikh tamat will be 31 december 2021
if TarikhMohon 1 july 2021 - 31 dicember 2021, with tempohmohon 1 year
tarikh tamat will be 31 december 2022
hope u understand
thanks
on my form have fixed exp date "31 december" for year it will +1 year .
below is my current code
C#:
Private Sub TarikhTamat_GotFocus()
TarikhTamat = "31 Disember " & Year(TarikhMohon) + TempohMohon
End Sub
TempohMohon = textbox with number 1 --> 5. 1 equal to 1 year
TarikhMohon =current date
TarikhTamat = exp date with 31 december
so i want do this,
if TarikhMohon 1 january 2021 - 30 june 2021, with tempohmohon 1 year
tarikh tamat will be 31 december 2021
if TarikhMohon 1 july 2021 - 31 dicember 2021, with tempohmohon 1 year
tarikh tamat will be 31 december 2022
hope u understand
thanks