Date Issues With Nov & Dec 99 Paradox Dos 4.0 
Author Message
 Date Issues With Nov & Dec 99 Paradox Dos 4.0
Have been using PDOX Dos 4.0 for several years.

We have encountered the following issues:

November 1999 does NOT GROUP in reporting.
December 1999 DOES GROUP in reporting but SORTS before Jan 1999-Oct 1999
2000 dates appear to work properly.

Any fixes?



Thu, 13 Jun 2002 03:00:00 GMT
 Date Issues With Nov & Dec 99 Paradox Dos 4.0

This is a known bug that has appeared in this group many times.
The work arround is still the same <g>, create a Month field  and use
that as  part of your sort. (after you populate it with your code.
Scan [yourfield]=Month([datefield]) EndScan  )

Steve U



Quote:
>Have been using PDOX Dos 4.0 for several years.

>We have encountered the following issues:

>November 1999 does NOT GROUP in reporting.
>December 1999 DOES GROUP in reporting but SORTS before Jan 1999-Oct 1999
>2000 dates appear to work properly.

>Any fixes?

,        _
,       | \                           Steve Urbach
,       |  )erek

,  / / /                              http://www.greenduck.com


Thu, 13 Jun 2002 03:00:00 GMT
 Date Issues With Nov & Dec 99 Paradox Dos 4.0

Quote:

> November 1999 does NOT GROUP in reporting.
> December 1999 DOES GROUP in reporting but SORTS before Jan 1999-Oct 1999
> 2000 dates appear to work properly.

your findings are absolutely correct.. and well known.. this is a known bug
in range=month in the report generator.. you need to make a "sort" field
that you can seed and group on, instead of the way it is being done now..

--
Steve Green
Corel CTech - Paradox
Diamond Software Group, Inc.
Waldorf, Maryland  USA

http://www.diamondsg.com



Thu, 13 Jun 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Reminder: IOPADS '99 extended deadline, Nov. 23

2. Paradox 4.0 Dos & Application Workshop Errors

3. APPRO- Activation after 31 dec 99.....

4. Paradox 4.0 (DOS) migration from Netware 3.12 to NT 4.0

5. Unable to run Paradox 4.0 for DOS from DOS

6. sharing tables between Paradox 4.0 for DOS and Paradox 9

7. Dos Paradox (4.0) vs Win Paradox 8 : Performance

8. Paradox DOS 4.0/4.5 to Paradox for Windows

9. Paradox 4.0 DOS to Paradox win 4.5

10. 99 for 99 days

11. CFP: WORKSHOP ON SPATIO-TEMPORAL DATABASE MANAGEMENT STDBM'99 (co-located with VLDB'99)

12. paradox 9, paradox 4.02 for dos, and index out of date errors


 
Powered by phpBB® Forum Software