F
Fable
I build a database within excel where the Date is the unique record
value, however Im having problems since my PC is English (Regional
Setting, Language) and some the End Users is set in Spanish.
The problem being English date format is mm/dd/yy and Spanish is
dd/mm/aa (AA being “Año” or Year translated). When a search is
performed on a Spanish PC the Excel file does not find anything since
the Database on has all transformed into usable format.
Example: August 1, 2005 in the database it would look like “08/01/05”
on an English PC, but when a Spanish PC End User does a search it turn
into “01/08/YYYY”
Is there a way to force the Date to change and stay into an English
date format mm/dd/yy both on Upon Data Entrée and within the database.
Thanking you in advance,
value, however Im having problems since my PC is English (Regional
Setting, Language) and some the End Users is set in Spanish.
The problem being English date format is mm/dd/yy and Spanish is
dd/mm/aa (AA being “Año” or Year translated). When a search is
performed on a Spanish PC the Excel file does not find anything since
the Database on has all transformed into usable format.
Example: August 1, 2005 in the database it would look like “08/01/05”
on an English PC, but when a Spanish PC End User does a search it turn
into “01/08/YYYY”
Is there a way to force the Date to change and stay into an English
date format mm/dd/yy both on Upon Data Entrée and within the database.
Thanking you in advance,