Prev: Toolbar - Details
Next: Weird bbrowser problem
From: Lu on 7 Jan 2010 03:14
Hi VO experts!

In our applications we use sometimes the dateformat DD.MM.JJ HH:MM in
the bbrowser. This column is a varchar(14) in the database. I know
this is not good but this application is some years old.

local dDate as Date
dDate := CToD(Left(self:odcbBrowser:Server:Fieldget(#Date),8))

The above code worked until 31.12.2009. Now, 2010 the date is
converted to 1910 and not 2010.

Has somebody the same problem? We use VO 2.7b

Lu
From: E®!k /!sser on 7 Jan 2010 03:24
Lu,
Have a look at the SetEpoch() function.

hth

Erik



"Lu" <lu2k(a)hotmail.com> schreef in bericht
news:5305c389-f0fd-45b6-bf97-473bd29d2703(a)c3g2000yqd.googlegroups.com...
> Hi VO experts!
>
> In our applications we use sometimes the dateformat DD.MM.JJ HH:MM in
> the bbrowser. This column is a varchar(14) in the database. I know
> this is not good but this application is some years old.
>
> local dDate as Date
> dDate := CToD(Left(self:odcbBrowser:Server:Fieldget(#Date),8))
>
> The above code worked until 31.12.2009. Now, 2010 the date is
> converted to 1910 and not 2010.
>
> Has somebody the same problem? We use VO 2.7b
>
> Lu

From: Lu on 7 Jan 2010 03:50
Thank you Erik, now it works again. :-)

I did not know this function.

Lu

From: Johan Nel on 7 Jan 2010 07:02
Hi Lu,

Tip coming way back from Clipper days.

In your Startup function:

SetEpoch(Year(Today()) - 50)

Depending your environment you might have to change the 50 to something
else, depending the date ranges you working with.

HTH,

Johan Nel
Pretoria, South Africa.

Lu wrote:
> Thank you Erik, now it works again. :-)
>
> I did not know this function.
>
> Lu
>
From: Lu on 7 Jan 2010 07:49
Thanks Johan for your tip. Thats a good idea.

Lu

 | 
Pages: 1
Prev: Toolbar - Details
Next: Weird bbrowser problem