Hello Guys,
I have create the following file Path which looks for a document in the form LastnameFirstname.pdf
However, I would like it in the form LastnameFirstnameYYYY.pdf with YYYY = any year (i.e.: SmithJohn2021.pdf)but I want to save YYYY into a variable to run a check on it later (Let's say: IF within this year or before THEN do something...)
1st - How do I create the LastnameFirstnameYYYY.pdf? then some advise on the IF check
(I know I need to first save the current year into a variable and then compare it with the year at the end of the FileName then...)
Thanks for the help
I have create the following file Path which looks for a document in the form LastnameFirstname.pdf
Code:
strFolderPath = CurrentProject.Path
strFilePath = strFolderPath & "\States\" & Me.cboState.Column(0) & "\" & Me.cboName.Column(2) & Me.cboName.Column(3) & ".pdf"
1st - How do I create the LastnameFirstnameYYYY.pdf? then some advise on the IF check
(I know I need to first save the current year into a variable and then compare it with the year at the end of the FileName then...)
Thanks for the help