Date Format and Input Mask for Access 2000

  Gilliann 11:55 03 Feb 2005
Locked

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 2005

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

Sat

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

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Print designer Kelly Anna on confident mark making & modern femininity

New iMac Pro release date, UK price & specs rumours

Comment créer, utiliser et supprimer son compte Facebook ?