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.
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.