inexperienced sql user Calculating total days between datefields

I have two fields
Date entered|Date left
and i need to calculate the difference in days between the two fields to
look like this
Date entered|Date left|Total days taken
I am trying to use the datediff command like
=datediff(d,Fields!dateentered.value,Fields!date_left.value)
But this isnt working. Anyone have any ideas how i can do this?No matter i found that doing the datediff in the select statment rather than
in an expression works.
"Shaun Longhurst" wrote:
> I have two fields
> Date entered|Date left
> and i need to calculate the difference in days between the two fields to
> look like this
> Date entered|Date left|Total days taken
> I am trying to use the datediff command like
> =datediff(d,Fields!dateentered.value,Fields!date_left.value)
> But this isnt working. Anyone have any ideas how i can do this?|||Place the calculation on the DataSet and reference it in the report table
just as any other column.
What exactly isn't working?
The following syntax works for two dates inside a SQL Select statement:
DATEDIFF(d, FirstDate, LastDate) AS DurationA
"Shaun Longhurst" wrote:
> I have two fields
> Date entered|Date left
> and i need to calculate the difference in days between the two fields to
> look like this
> Date entered|Date left|Total days taken
> I am trying to use the datediff command like
> =datediff(d,Fields!dateentered.value,Fields!date_left.value)
> But this isnt working. Anyone have any ideas how i can do this?

indexes

Does anyone know how to easily calculate an index? please
dont give me that site "Estimating the size of a table
with an index" because it's complicated to read much less
understand...PP,
if you want a non-analytical way, then empirically is the easiest, and often
the most accurate. Simply create the index and bulk load the table with 1000
rows then note the index sixe. Add another 1000 rows and note the size. Do
this several times then you can extrapolate to any number of rows to know
the index size.
HTH,
Paul Ibison

indexes

Does anyone know how to easily calculate an index? please
dont give me that site "Estimating the size of a table
with an index" because it's complicated to read much less
understand...PP,
if you want a non-analytical way, then empirically is the easiest, and often
the most accurate. Simply create the index and bulk load the table with 1000
rows then note the index sixe. Add another 1000 rows and note the size. Do
this several times then you can extrapolate to any number of rows to know
the index size.
HTH,
Paul Ibison

indexes

Does anyone know how to easily calculate an index? please
dont give me that site "Estimating the size of a table
with an index" because it's complicated to read much less
understand...
PP,
if you want a non-analytical way, then empirically is the easiest, and often
the most accurate. Simply create the index and bulk load the table with 1000
rows then note the index sixe. Add another 1000 rows and note the size. Do
this several times then you can extrapolate to any number of rows to know
the index size.
HTH,
Paul Ibison