ExcelBanter - How to get only the year in the date format in Access

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How to get only the year in the date format in Access (https://www.excelbanter.com/new-users-excel/4826-how-get-only-year-date-format-access.html)

yanu

How to get only the year in the date format in Access

How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically

Ragdyer

Custom format the cell as:
yy

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"yanu" wrote in message
...
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically

All times are GMT +1. The time now is 11:51 AM.