 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / January 2007Date Format/Input Mask
I need my Date field to possess the following format: Jan-05-1999 How do I change the Date Format/Input Mask to accomplish this? Thanks! John > I need my Date field to possess the following format: Jan-05-1999 > [quoted text clipped - 3 lines] > > John With the understanding that dates are always stored in the tables exactly the same regardless of format or input mask... Use a format property of "mmm-dd-yyyy"  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com >> I need my Date field to possess the following format: Jan-05-1999 >> [quoted text clipped - 8 lines] > >Use a format property of "mmm-dd-yyyy" jmarr02s The input mask is fine for the person entering the data. How the data is actually stored in the table is really unimportant. However, when you pull dates out of the table then format the display: Format({date field},"Mmm-dd-yyyy") Chuck |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.