Rabu, 03 Februari 2016

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



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



Tidak ada komentar:

Posting Komentar