Format of date in database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Jeff Boyce said:
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


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
Click to expand...
 
Back
Top