dolano
2nd cousin of Rincewind
- Local time
- Today, 05:50
- Joined
- Jul 19, 2006
- Messages
- 28
Good day. I have a report which shows all cables pulled and their date. I had them grouped by week, but, I have being asked to group them by the day that they have being pulled.
So, I decided to mess around with the Format expression and came up with this.
=Format$([Cable Pull Date],"dd/mm/yy",1,0)
however I am not completely sure how the parameters of the expression work fully.
This will return a group header of the date the cable was pulled in some cases and on occassion it groups two or more days under the one date. eg cables pulled on the 4th, 5th, 6th will appear under the group heading of the 4th.
Any tips, or should I use a different approach?
Thank you for your time.
Sorry, me idiot (duh) (and no comments on the self comment please)
I set the grouping order to group by day instead of group by week which it had being set to.
Paul
So, I decided to mess around with the Format expression and came up with this.
=Format$([Cable Pull Date],"dd/mm/yy",1,0)
however I am not completely sure how the parameters of the expression work fully.
This will return a group header of the date the cable was pulled in some cases and on occassion it groups two or more days under the one date. eg cables pulled on the 4th, 5th, 6th will appear under the group heading of the 4th.
Any tips, or should I use a different approach?
Thank you for your time.
Sorry, me idiot (duh) (and no comments on the self comment please)
I set the grouping order to group by day instead of group by week which it had being set to.
Paul
Last edited:
