Probably a very simplistic one for the Excel crowd but I need to convert the following time/date field in order when the data is pivotted I'm able to present by Month and also by week.
06/05/2011 06:14:51 (this is a resolution detail, where the time aspect can be dropped)
Thanks in advance!
Cheers, Paul.
EDIT -
Bodged it with LEFT and DATEVALUE and then Grouping. Wood for trees moment.
06/05/2011 06:14:51 (this is a resolution detail, where the time aspect can be dropped)
Thanks in advance!
Cheers, Paul.
EDIT -
Bodged it with LEFT and DATEVALUE and then Grouping. Wood for trees moment.
Last edited: