geoffdavis
asked on
US and International date formate for evaluation version
Hello Experts,
Our company has a software package that has a 45 day evalution version. Part of the evaluation check is the install date and current date. Everything worked fine in the US but we recently started marketing internationally and with the date format difference for international dates, we have run into problems. Since 'everyone' is doing it I have to think that we have missed the mark on our approach. Any suggestions would be helpful.
Thanks,
Geoff
Our company has a software package that has a 45 day evalution version. Part of the evaluation check is the install date and current date. Everything worked fine in the US but we recently started marketing internationally and with the date format difference for international dates, we have run into problems. Since 'everyone' is doing it I have to think that we have missed the mark on our approach. Any suggestions would be helpful.
Thanks,
Geoff
ASKER
We store the date in the format "mm/dd/yyyy" and then pass it to the Cdate function which turns it into a Date datatype.
Note that Cdate is locale sensitive - 04/01/2006 is 1 APR in the US, but 4 JAN in other countries.
ASKER
And that would be the question. Does a function exist that identifies which locale is current and therefore which format to read/process?
GetLocaleInfoEx:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/intl/nls_GetLocaleInfoEx.asp
In .NET, see UserPreferenceCategory.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/intl/nls_GetLocaleInfoEx.asp
In .NET, see UserPreferenceCategory.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Right on. I'll check these out tomorrow and get back to you. Thanks.
Are you storing the install date as US format or using the regional settings to store it.