Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date range in select statement
Message
From
05/12/2001 12:26:44
John Deupree
Long Term Care Authority
Tulsa, Oklahoma, United States
 
 
To
05/12/2001 12:13:13
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00589506
Message ID:
00589971
Views:
40
Grouping the status doesn't work since there are other statuses between the 'grouped' status. eg
suspend     01/01/2001
resume      01/30/2001
suspend     03/01/2001
resume      03/30/2001
We usuallly look at the time a consumer was suspended in a date range. For instance, consumer was suspended for 30 days in Jan or 60 days between Jan 1 and May 1, in the above example. Adding an end date field is looking more and more attractive. :)

John

>Will adding a group on Status work?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform