Date Formatting

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.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.
>|||That worked pefectly. 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.
> >
> >
>