| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
| Format an excel column as a date for a 5 day week for a year. | Excel Discussion (Misc queries) | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
| Date format collapses diagram | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
Hybrid Mode
