Date Format and Input Mask for Access 2000

  Gilliann 11:55 03 Feb 05

I would like to change the date format in Access to show 'day and month only'. I do not want the year displayed, I know how to set up a custom date in Excel but Access has me completely fooled - any one help please

  sat481 15:36 03 Feb 05

In the Format put

dd mm (For 03 02)
dd mmm (For 03 Feb)

And it will then only show the day and month

hope this helps


This thread is now locked and can not be replied to.

Apple Event as it happened | Apple October Event live blog: Apple unveils new MacBook Pro at…

1995-2015: How technology has changed the world in 20 years

Graeme Messer's exhibition aims to challenge fears and insecurities

New MacBook Pro release date, price and specs | New MacBook Pro 2016 announced: Now with Touch Bar…