Hey all,
should be a pretty simple question but I am having problems breaking a variable which holds a short date (dd/mm/yyyy) into seperate parts. I get a mismatch error. Anyone know what I'm doing wrong here?
Thanks
should be a pretty simple question but I am having problems breaking a variable which holds a short date (dd/mm/yyyy) into seperate parts. I get a mismatch error. Anyone know what I'm doing wrong here?
Code:
Dim last As String
Dim today As Date
Dim myday As Integer
Dim mymonth As Integer
Dim myyear As Integer
review = Me.content_review_period [COLOR=seagreen]'short date textbox on same form[/COLOR]
last = Me.page_last_updated [COLOR=seagreen]'short date textbox on same form[/COLOR]
today = Date
myday = Left(last, 2)
mymonth = Left(last, 5)
MsgBox (mymonth) [COLOR=seagreen]'displays the error.[/COLOR]
myyear = Right(last, 4)
Thanks