Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Date range in select statement
Message
De
05/12/2001 12:26:44
John Deupree
Long Term Care Authority
Tulsa, Oklahoma, États-Unis
 
 
À
05/12/2001 12:13:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00589506
Message ID:
00589971
Vues:
41
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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform