ultimo dia de mes
Function UltimoDiaMes(Mes as integer, AƱo as integer) as integer
if Mes<1 or Mes>12 then exit function
UltimoDiaMes = 30 - (Mes = 4 Or Mes = 6 Or Mes = 9 Or Mes = 11) + (Mes = 2) * (2 + (AƱo Mod 4 = 0))
end function
private sub Form_Load()
msgbox UltimoDiaMes(4,2000)
end sub
Espero que te sirva esta función.
if Mes<1 or Mes>12 then exit function
UltimoDiaMes = 30 - (Mes = 4 Or Mes = 6 Or Mes = 9 Or Mes = 11) + (Mes = 2) * (2 + (AƱo Mod 4 = 0))
end function
private sub Form_Load()
msgbox UltimoDiaMes(4,2000)
end sub
Espero que te sirva esta función.
