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


paradox reads dates US style

Posted on 2012-09-11
Medium Priority
Last Modified: 2012-09-11
After a hard disk crash I have reinstalled Paradox to a new drive.
However, queries that selected by date now read the date as American.
Thus a query that reads '>05/07/2012' (later than 5 July) now returns data where date > 07/05/2012 (later than 7th May).
I have checked the system settings and all UK. The BDE does not appear to refer to a language, nor do settings in Paradox. I am wearing Union Jack underpants. Still no British result.
Does anybody know how Paradox/BDE read dates? Are there setting I am missing?
I have put this on a Delphi site as maybe they know?
Question by:ClaytonGlass
  • 2
LVL 23

Accepted Solution

Ferruccio Accalai earned 1600 total points
ID: 38385808
@after a hard disk crash
If you mean that you have reinstalled a whole OS on a new hard disk, guessing that the OS is W7, you have to change your regional settings to the yours.
There's a little bug in Vista/W7 about it: even if your regional setting is automatically selected by the installation process, it must be changed at least one time to be correct.
So try changing your regional settings to some other and confirm it, then just set it back to UK.

Author Closing Comment

ID: 38385867
Thank you!

Author Comment

ID: 38385897
A follow up to Ferucci's answer:
There is also a date setting in the BDE/system/format/dates
 Setting Mode to 1 and  both leading zeroessettings  to TRUE also did the trick.
Not to decry his answer but one for the knowledgebase!

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

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