We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

US and International date formate for evaluation version

geoffdavis
geoffdavis asked
on
Medium Priority
210 Views
Last Modified: 2012-05-05
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
Comment
Watch Question

hes
CERTIFIED EXPERT

Commented:
How are you doing your compare of the install date vs current.
Are you storing the install date as US format or using the regional settings to store it.

Author

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

Commented:
Note that Cdate is locale sensitive - 04/01/2006 is 1 APR in the US, but 4 JAN in other countries.

Author

Commented:
And that would be the question. Does a function exist that identifies which locale is current and therefore which format to read/process?

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Right on. I'll check these out tomorrow and get back to you. Thanks.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.