microsoft.public.access.gettingstarted

"Jeff Boyce" wrote:

> 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
>
>