Re: date - date gives surprise result
- From: Alan Secker <alan(delete this bit)@asandco.co.uk>
- Date: Thu, 08 Dec 2005 13:29:17 +0000
On Wed, 07 Dec 2005 23:44:06 +0000, Stephen Quinn wrote:
> Alan
>
> Are they dates or strings??
> 01/11/2005 is a string representation not numeric
>
> Maybe you need
> CTOD( atfr[28] ) - CTOD( dfirstday )
>
> or maybe the typo you show here (firsday)
>
>> dfirstday holds 01/11/2005
>> ? atfr[28] - dfirsday should produce 5 but returns -36520
>
> HTH
> Steve
Funny. I woke up after a couple of hours knowing it was a century
related problem but I haven't pinned down where it went haywire.
I set the default century on startup which is why I ignored that
to start with. Thanks everyone.
Alan
.
- References:
- date - date gives surprise result
- From: Alan Secker
- Re: date - date gives surprise result
- From: Stephen Quinn
- date - date gives surprise result
- Prev by Date: Re: Clipper books - free for the taking
- Next by Date: Re: Clipper books - free for the taking
- Previous by thread: Re: date - date gives surprise result
- Next by thread: Re: date - date gives surprise result
- Index(es):
Relevant Pages
|
