"John Geddes" <john_g@alamode.com> wrote in message
news:e2OV1FV4EHA.2568@TK2MSFTNGP11.phx.gbl...
> I know this has probably been beaten to death, but I still have not found
a
> way to use datetime in a matrix. I have a timestamp field with the value
of
> datetime.
>
> I want to group by the date, not using the time. When I format the date,
it
> still groups by the datetime, not the date only. I also tried to
> concatenate the date parts, but 11/10 comes right after 11/1.
>
> Any ideas?
>
> Thanks.
>
>

"Robert Bruckner [MSFT]" <robruc@online.microsoft.com> wrote in message
news:OwI$$MV4EHA.3388@TK2MSFTNGP15.phx.gbl...
> You can always use function calls to generate numbers from the DateTime
> value. For instance, you can use this function for the grouping (and
achieve
> correct date ordering):
> =Year(Fields!Date.Value) * 10000 + Month(Fields!Date.Value) * 100 +
> Day(Fields!Date.Value)
>
> MSDN references:
> * http://msdn.microsoft.com/library/en-us/vblr7/html/vafctday.asp
> * http://msdn.microsoft.com/library/en-us/vblr7/html/vafctmonth.asp
> * http://msdn.microsoft.com/library/en-us/vblr7/html/vafctyear.asp
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> "John Geddes" <john_g@alamode.com> wrote in message
> news:e2OV1FV4EHA.2568@TK2MSFTNGP11.phx.gbl...
> > I know this has probably been beaten to death, but I still have not
found
> a
> > way to use datetime in a matrix. I have a timestamp field with the
value
> of
> > datetime.
> >
> > I want to group by the date, not using the time. When I format the
date,
> it
> > still groups by the datetime, not the date only. I also tried to
> > concatenate the date parts, but 11/10 comes right after 11/1.
> >
> > Any ideas?
> >
> > Thanks.
> >
> >
>
>