VFP BUG: GOMONTH() returns blank date for dates prior to {01/01/1753} 
Author Message
 VFP BUG: GOMONTH() returns blank date for dates prior to {01/01/1753}


Quote:
>Visual FoxPro 3.0 Returns Blank Date if you try to use GOMONTH()
>function on dates prior to {01/01/1753}

>I know this is not critical, but if you are writing a Calander
>or some other program that tries to advance months or trying to
>find the Last day of a month, you could end-up in never ending
>loops!!!

>Aby Thomas
>Northwestern University

I agree with your concerns with this function in a calendar, but what I
want to know is...

        How did you find this bug:)
           Did you find it accidently or on purpose?

Congradulations on Northwestern's fine football season.  I was rooting for them
in the Rose Bowl.

Phillip



Mon, 22 Jun 1998 03:00:00 GMT  
 VFP BUG: GOMONTH() returns blank date for dates prior to {01/01/1753}
Visual FoxPro 3.0 Returns Blank Date if you try to use GOMONTH()
function on dates prior to {01/01/1753}

I know this is not critical, but if you are writing a Calander
or some other program that tries to advance months or trying to
find the Last day of a month, you could end-up in never ending
loops!!!

Aby Thomas
Northwestern University



Mon, 22 Jun 1998 03:00:00 GMT  
 VFP BUG: GOMONTH() returns blank date for dates prior to {01/01/1753}

Quote:

> How did you find this bug:)
> Did you find it accidently or on purpose?

I don't know how the original poster found it, but I have found similar
bugs in other programs.  I just want to say that before people jump in to
question why anyone would ever need a date such as that, there are
applications which chronicle history, for instance, and store dates much
further back than that.  There are also music catalogs which have pieces
written further back than that, etc.  I remember arguing once with a
former boss about whether a date before 1900 was required (the software
which was not FoxPro did not handle it), and I could not make her
understand that the application was for a {*filter*} cancer screening clinic,
and we routinely had patients who were more than 90 (in 1990) years old.
She wanted a work around where someone could enter 92, and it would refer
to 1892, but 89 would refer to 1989, AND she wanted it to float with the
year so that any date greater than today was 100 years ago, and any lower
than that was this century.  It was a long explanations of the
ramifications of that one. :)

- John
--
Opinions expressed herein are, in fact, also those of my employer.



Mon, 22 Jun 1998 03:00:00 GMT  
 VFP BUG: GOMONTH() returns blank date for dates prior to {01/01/1753}
Hmmmm.....

Isn't 1753 the year the pope changed the calendar?
and isn't there a period in 1753 where there are NO dates?



Tue, 23 Jun 1998 03:00:00 GMT  
 VFP BUG: GOMONTH() returns blank date for dates prior to {01/01/1753}

:Visual FoxPro 3.0 Returns Blank Date if you try to use GOMONTH()
:function on dates prior to {01/01/1753}

:I know this is not critical, but if you are writing a Calander
:or some other program that tries to advance months or trying to
:find the Last day of a month, you could end-up in never ending
:loops!!!

Actually, I don't think it's a bug. If it returned the same date that
you sent it, that, I would consider a bug. But since it returns an
empty date, it can easily be checked for.

You might also want to note the following excerpt from the on-line
help about system dates:

******************** Quote from MS VFP on-line help

SYS(1)

Returns the current system date as a Julian day number character
string.

<snip>

The value returned by SYS(1) is valid in the U.S.A. You can get Visual
FoxPro versions for any system date after September 14, 1752, and
before December 31, 9999.

**************************** End Quote

As you can see, it might imply that dates before 09/14/1752 might not
be supported in all date functions. This might be the source of your
"bug."

Happy foxing.

Daryl dmc
--
 Daryl Moore
 MooSoft, The Sports Information Specialists (TM)

 http://www.wolfenet.com/~moosoft       fax: (206) 489-3985



Tue, 23 Jun 1998 03:00:00 GMT  
 VFP BUG: GOMONTH() returns blank date for dates prior to {01/01/1753}
Texas Howdy,

  Didn't England and the U.S. colonies adopt the Gregorian
calendar around that time (9/14/1752).  Something about that
date jogs some deep-rooted brain cell.  Any earlier date
should be notated by which calendar was used, but the brain
cell that contained what those codes were dried up along time
ago.  Just my .02, thanks.



Fri, 26 Jun 1998 03:00:00 GMT  
 
 [ 6 post ] 

 Relevant Pages 

1. vfp7 gomonth on datetime field returns date field

2. GoMonth Date Calculation Problem

3. VFP ODBC and Blank dates fields

4. VFP ODBC to Fox 2.6 table: Blank date problem

5. How do you replace a date field with blanks

6. / / that displays for blank dates

7. blank date problem

8. Date - become Blank

9. SQL Server Blank Dates

10. Dates and Date Ranges

11. Record Set Date Compare to Mem Var Date

12. foxpro for windows 2.6 app returns source out of date

 

 
Powered by phpBB® Forum Software