MSAccess date format

  • Thread starter Thread starter Scott
  • Start date Start date
In what context are you referring? Storing data? Displaying data in a
form? Displaying data in a query? What?

Dates in Access are stored in the same format, the "Date/Time format".
There are a variety of ways to display the data, depending on the context,
hence my question.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Sorry for not enough info.... old coot new to this ... anyway, I am trying to
display mm/dd only in the database or in the form. When I format or use a
mask, the format is only mm/dd/yyyy. I tried the "Date/Time format" and that
is also mm/dd/yyyy. I do not want to display the year, only mm/dd. I
finally ended up formating as Text and entering data that way but there
should be an option for mm/dd.
Appreciate any suggestions and help.
 
Within Access the only date/time datatype recognized is mm/dd/yyyy hh:nn:ss

It is stored internally as a double. Some input will be assumed. For
instance, unless you enter a year, Access assumes the current year, so you
can enter 5/3 and Access will assume 5/3/2008. An Input Mask can force you
to enter a year or the time or any other part of a date, but it will always
be stored as a double, unless it cannot be resolved. In that case a type
mis-match will occur.

The display is another matter entirely. If you use: mm/dd as the Format
property in a form, you will see 05/03 displayed. Because data entry will
assume the current year, it will still store 05/03/2008.
 
Back
Top