Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread Developing for different computer DATE formats
Thu, Dec 18 2008 9:17 PMPermanent Link

Pat
Hi all,

DBISAM v4, D6,  XP

My app works very nicely on my XP development machine (and a couple
other machines) with the date setting of dd/mm/yy in the Control Panel
| Regional....

I wanted to test it with Vista. I loaded a VMware clean Vista install,
and my app, and now its broke  Frown

It does not like the default setting of M/d/yyyy that Vista gives it
(I remember now I had to change this date setting on new XP installs
also).

So the obvious question is HOW do I develope my app to factor in the
various flavours of the date settings that users have? Do I use the
ANSI something for every occurance of the DATE in my application?

Regards,
Pat
Fri, Dec 19 2008 2:18 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Pat


Why not just set ShortDateFormat and LongDateFormat?

Roy Lambert [Team Elevate]
Fri, Dec 19 2008 2:28 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Pat


Just seen your post on the CodeGear forums and it adds an extra dimension. My answer was purely for display purposes. For database if using sql I'd follow the suggestion on using parameters or, as with filters, use the built in functions in the engine eg AnsiDateToStr , AnsiDateTimeToStr etc

Roy Lambert [Team Elevate]
Fri, Dec 19 2008 4:18 AMPermanent Link

Pat
Hi Roy,

>For database if using sql I'd follow the suggestion on using parameters or, as with filters, use the built in functions in the engine eg AnsiDateToStr , AnsiDateTimeToStr etc

Thanks for that Roy

>Just seen your post on the CodeGear forums

Yeah, first time I visited there for about 6 months. I pointed my
newsreader (Agent) to  forums.borland.com  as usual but it could not
connect. I did some scratching around and found
https://forums.codegear.com/category.jspa?categoryID=15

Roy do you know what the replacement for "forums.borland.com" is? I
would like to use Agent instead of the web browser.

Pat

Fri, Dec 19 2008 4:33 AMPermanent Link

Pat
>Roy do you know what the replacement for "forums.borland.com" is? I
>would like to use Agent instead of the web browser.

Cancel that Smile I just tried  forums.codegear.com  again & I got all
the goodies. I tried that addy earlier and only got DelphiPrism
newsgroups, ah well, not to worry.
Fri, Dec 19 2008 2:16 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Pat,

<< I wanted to test it with Vista. I loaded a VMware clean Vista install,
and my app, and now its broke  Frown>>

What part is broken ?  DBISAM 4.x uses ANSI date/time formatting for
everything, so it will be unaffected by changes in the OS regional settings.

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, Dec 19 2008 6:11 PMPermanent Link

Pat
Hi Tim,

><< I wanted to test it with Vista. I loaded a VMware clean Vista install,
>and my app, and now its broke  Frown>>
>
>What part is broken ?  DBISAM 4.x uses ANSI date/time formatting for
>everything, so it will be unaffected by changes in the OS regional settings.

It looks like I (as the user) was breaking it. In the reports I was
keying in DATE criteria in dd/mm/yy format and not respecting the
operating system's M/d/yyyy format. If I keyin M/d/yyyy format my
report works OK.

I guess I hit the panic button when Vista took me out of my comfort
zone (at least I learned a bit more in troubleshooting).

Pat
Image