[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

US and International date formate for evaluation version

Posted on 2006-04-05
8
Medium Priority
?
194 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
0
Comment
Question by:geoffdavis
  • 3
  • 3
7 Comments
 
LVL 20

Expert Comment

by:hes
ID: 16385856
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.
0
 

Author Comment

by:geoffdavis
ID: 16385910
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.
0
 
LVL 22

Expert Comment

by:cookre
ID: 16388240
Note that Cdate is locale sensitive - 04/01/2006 is 1 APR in the US, but 4 JAN in other countries.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:geoffdavis
ID: 16388292
And that would be the question. Does a function exist that identifies which locale is current and therefore which format to read/process?
0
 
LVL 22

Expert Comment

by:cookre
ID: 16388729
0
 
LVL 22

Accepted Solution

by:
cookre earned 750 total points
ID: 16388733
0
 

Author Comment

by:geoffdavis
ID: 16388753
Right on. I'll check these out tomorrow and get back to you. Thanks.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn different types of Android Layout and some basics of an Android App.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
Loops Section Overview

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question