Display The last digit of a year

  • Thread starter Thread starter Kevbro7189
  • Start date Start date
K

Kevbro7189

I have a table with a Date/Time field in it. I use this table to fill out a
form on which I use that date. On the same form I need to enter in a block
the last digit of the year which is in the Date/Time field.
Example;

Field = Jan 01, 2008 13:53
I would want a Text Box to display 8
 
Kevbro7189 said:
I have a table with a Date/Time field in it. I use this table to fill out
a
form on which I use that date. On the same form I need to enter in a
block
the last digit of the year which is in the Date/Time field.
Example;

Field = Jan 01, 2008 13:53
I would want a Text Box to display 8
Click to expand...


=Right$(Year([Acquired Date]),1)

Replace "Acquired Date" with the name of your Date/Time field.
 
Thank you. it works!!!!

Brendan Reynolds said:
Kevbro7189 said:
I have a table with a Date/Time field in it. I use this table to fill out
a
form on which I use that date. On the same form I need to enter in a
block
the last digit of the year which is in the Date/Time field.
Example;

Field = Jan 01, 2008 13:53
I would want a Text Box to display 8
Click to expand...


=Right$(Year([Acquired Date]),1)

Replace "Acquired Date" with the name of your Date/Time field.
Click to expand...
 
Back
Top