Prev: SQLServer 2005 + VO2Ado + Deadlock
Next: RegisterHotKey(
From: cwb on 12 Jan 2010 06:32
Good morning,

I have a problem since 2010 comparing dates.

Getting a date from a database ( e.g. 12.01.10 ) is the century 1910
and not 2010.
I tried setting the SetEpoch() function to 2000, 2005,... without any
changes - I always get 1910 !

Does someone have any ideas ?

Thanks Christian
From: Willie Moore on 12 Jan 2010 07:16
Christian,

Put the SetEpouch in your start method and you shouldn't have any problems.
This is mine: SetEpoch(1960)

Regards,
Willie

"cwb" <cwbusse(a)web.de> wrote in message
news:c2212623-430b-4a80-8247-71a4467b2215(a)e37g2000yqn.googlegroups.com...
> Good morning,
>
> I have a problem since 2010 comparing dates.
>
> Getting a date from a database ( e.g. 12.01.10 ) is the century 1910
> and not 2010.
> I tried setting the SetEpoch() function to 2000, 2005,... without any
> changes - I always get 1910 !
>
> Does someone have any ideas ?
>
> Thanks Christian
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 4763 (20100112) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>

__________ Information from ESET NOD32 Antivirus, version of virus signature database 4763 (20100112) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com



From: Johan Nel on 12 Jan 2010 07:34
Christian,

As Willie indicated will do the trick, however to keep it in rolling
form:

SetEpoch(Year(Today()) - 50)

Regards,

Johan Nel
Pretoria, South Africa.

On Jan 12, 2:16 pm, "Willie Moore" <will...(a)wmconsulting.com> wrote:
> Christian,
>
> Put the SetEpouch in your start method and you shouldn't have any problems.
> This is mine: SetEpoch(1960)
>
> Regards,
> Willie
>
> "cwb" <cwbu...(a)web.de> wrote in message
>
> news:c2212623-430b-4a80-8247-71a4467b2215(a)e37g2000yqn.googlegroups.com...
>
>
>
>
>
>
>
> > Good morning,
>
> > I have a problem since 2010 comparing dates.
>
> > Getting a date from a database ( e.g.  12.01.10 ) is the century 1910
> > and not 2010.
> > I tried setting the SetEpoch() function to 2000, 2005,... without any
> > changes - I always get 1910 !
>
> > Does someone have any ideas ?
>
> > Thanks Christian
>
> > __________ Information from ESET NOD32 Antivirus, version of virus
> > signature database 4763 (20100112) __________
>
> > The message was checked by ESET NOD32 Antivirus.
>
> >http://www.eset.com
>
> __________ Information from ESET NOD32 Antivirus, version of virus signature database 4763 (20100112) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com

From: cwb on 12 Jan 2010 08:06
Hi Willie,

I tried to set the SetEpoch(1960) in the start method.

But it doesn´t work for older entries.
New entries ( after setting the SetEpoch ) are working now, but the
old ones still have problems.


LOCDatum := Today() - 14
odbGPerson:Visitlast(12.01.10) >= LOCDatum -> always .F.

If I use CTOD(DTOC(odbGPerson:Visitlast)) >= LOCDatum it´s .T. and
works.

Johan,
I also tried this function without success for existing entries.

Thank´s Christian

From: Massimo Bighelli on 12 Jan 2010 09:32
Christian

look at setinternational()
setepoch() must follow setinternational()

Massimo Bighelli
ARCA Sistemi S.r.l.
www.arcasistemi.it
www.arcasistemi.eu


"cwb" <cwbusse(a)web.de> ha scritto nel messaggio
news:c2212623-430b-4a80-8247-71a4467b2215(a)e37g2000yqn.googlegroups.com...
> Good morning,
>
> I have a problem since 2010 comparing dates.
>
> Getting a date from a database ( e.g. 12.01.10 ) is the century 1910
> and not 2010.
> I tried setting the SetEpoch() function to 2000, 2005,... without any
> changes - I always get 1910 !
>
> Does someone have any ideas ?
>
> Thanks Christian

 |  Next  |  Last
Pages: 1 2 3
Prev: SQLServer 2005 + VO2Ado + Deadlock
Next: RegisterHotKey(