Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group by MONTH() and/or TTOD() for datetime fields
Message
From
10/07/1997 19:20:31
Jon Ziegler
Mannesmann Dematic Corp.
Solon, Ohio, United States
 
 
To
10/07/1997 12:41:24
Susan Piro
Northwestern University
Evanston, Illinois, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00039291
Message ID:
00039365
Views:
36
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform