General information
Category:
Reports & Report designer
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only