microsoft.public.access.gettingstarted

Tony

Perhaps a confusion of terms here...

Data is stored as it is stored. Data is displayed via the FORMAT property
(and function). Data is input via input masks. If your field is truly a
Date/Time field, you don't "feed" it only DDMMM data (that isn't a date).

Besides, if your database holds more than one year's data, won't there be
confusion about which YY the DDMMM is in?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"Tony Greer" wrote in message
news:7071AB96-09CE-46F1-A3B5-B7ADEB7AC26A@microsoft.com...
> As part of my database I want to include my clients' accounting year end
dates.
>
> Changed data type to Date\Time but I want the date to display as simply DD
> MMM. Can't find an input mask to do this so have made my own. Still
> displaying as DD MMM YY in datasheet.
>
> As the database is to be used to chart accounts and tax return completion
> over a number of years I need the year end date to exclude the year.
>
> Will I be able to do this later in the process (when I start creating
> queries etc) if the source data has the year?
>
> Help appreciated