Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Group by MONTH() and/or TTOD() for datetime fields
Message
De
10/07/1997 19:20:31
Jon Ziegler
Mannesmann Dematic Corp.
Solon, Ohio, États-Unis
 
 
À
10/07/1997 12:41:24
Susan Piro
Northwestern University
Evanston, Illinois, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00039291
Message ID:
00039365
Vues:
34
>Help! I've been trying to use MONTH() and TTOD() to group items on some reports. Sometimes the first day of the next month (.e.g, 07/01/97) is included with the prior month (e.g., June) info -- and is then shown again with the correct month. Does anyone have any ideas? Is this a VFP bug?

Try converting what you're grouping into character strings using STR( MONTH(dExpression), nLengthOfString ) or TTOC() instead of TTOD(). Once these item are converted into character strings, they can be padded with spaces using PADL() or a related PAD function, or can be manipulated in many more ways as needed.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform