Date formats - consistency across computers (1 Viewer)

HGCanada

Registered User.
Local time
Today, 10:34
Joined
Dec 30, 2016
Messages
82
I have a database with multiple users. They've requested a specific date format to ease data entry. There are many dates to enter, so I'd like to help them with this.

In earlier development of the database, I found that regardless of how I set up the date input on the forms, the date displayed differently on different computers. For example, on one computer, it displayed the date on the form as dd/mm/yyyy, and on another it displayed as mm/dd/yyyy. I ended up putting in date pickers, and making sure it displayed with the actually date letters (dd-MMM-yyyy) for them - just remove any possibility of confusion on which date they were entering. However, this may not be what the team wants.

Any advice for me on how to set this up for them? And what will happen to dates already entered?

Thanks.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:34
Joined
May 7, 2009
Messages
19,230
dates are stored in the
database as double type (date+time).
what you actually "see" is mere
representation of those doubles.

to make it easy, without requiring
any effort of programming, ask
the users to change their Date
Regional Setting to dd-MMM-yyyy.

Office programs along with others
uses the Computer's Regional Setting
to display and format numbers, dates,
time, etc.

Regional Setting is in the Computer's
Control Panel.
 

Users who are viewing this thread

Top Bottom