Re: [MS_AccessPros] Changing or creating a Date/Time format

 

jp-

The default format for date/time fields is Short Date, and that inherits the format from the system International settings.  If you get your company's Windows gurus to do a blanket change to everyone's date format setting in Windows, you have nothing to do.  If not, then you have to go to every table that has a date/time field and override with a custom dd-mm-yy setting.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Feb 3, 2016, at 5:39 PM, jpbrown0127@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

The company I am working for has changed the requirement for how the date looks to (dd-mm-yy).  How can I change or create this as an option in Date/Time?  I need this so the formating I created will not have to change.  As of right now, I had to go and change the field to short text instead of Date/Time.  Can anyone help with this?

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___