Access 2 Digit year in Access Text Box

C

CharlieFlow

Joined
Oct 19, 2017
Messages
2
Reaction score
1
Hello all,
I have a question to see if anyone can suggest anything.
I have a text unbound box that I need populated with the current Fiscal year which now for us is 2018, ok I Achieved that by doing this on the load property of the form:

Code: 
Private Sub Form_Load()
If Month(Date) > 9 Then
        TxtFY = Year(Date) + 1
    Else
        TxtFY = Year(Date)
    End If
   End Sub

it populates the textbox with 2018, great!, the question is how do i get this to display only two digits aka "18".
I tried "yy" on the format but that threw my year back in time. any suggestions on how to accomplish this via VBA?
 
Last edited by a moderator:
Welcome to PCR :).

I'm not too familiar with Access, but can you just extract the last two digits using the following instead of year(date):

Code: 
Right(Year(Date), 2)
 
Back
Top