datediff

Hi,
I'd like to calculate the days between 2 dates (data type:datetime).
unfortunately all I get in the preview report is #error and nothing
else. the 2 used date fields work when used seperately.
=DateDiff("day", Max(Fields!Date.Value), Min(Fields!Date.Value))
thanks!instead of using the word "day" use "d"
"florian" <florian.stammer@.gmail.com> wrote in message
news:1153840449.717417.120890@.i42g2000cwa.googlegroups.com...
> Hi,
> I'd like to calculate the days between 2 dates (data type:datetime).
> unfortunately all I get in the preview report is #error and nothing
> else. the 2 used date fields work when used seperately.
> =DateDiff("day", Max(Fields!Date.Value), Min(Fields!Date.Value))
>
> thanks!
>|||thanks it works!!!!
Ben Watts schrieb:
> instead of using the word "day" use "d"
> "florian" <florian.stammer@.gmail.com> wrote in message
> news:1153840449.717417.120890@.i42g2000cwa.googlegroups.com...
> > Hi,
> >
> > I'd like to calculate the days between 2 dates (data type:datetime).
> > unfortunately all I get in the preview report is #error and nothing
> > else. the 2 used date fields work when used seperately.
> >
> > =DateDiff("day", Max(Fields!Date.Value), Min(Fields!Date.Value))
> >
> >
> > thanks!
> >