Substracting two Dates

[#1]

Hi,

I want to substract two dates. And the output should be Number of Days.

I want to display it in a bar graph against dimension.

I used this as my expression

=interval(DateSent-DateReceived,'DD')

But i am getting No data to display.

It shows only when i select any field.

Help me with this.

Thanks and Regards

Keerthi

[jonathandienst]

Hi

To get the date difference in days, just subtract the first date from the second.

=DateSent-DateReceived

You could round this with Round(), Floor() or Ceil() according to your requirements.

HTH

Jonathan

[#3]

I am getting substracted date only when i select date received.

it should be displayed against a dimension in a chart.

How to do that ??

[jagan]

Hi,

If there are multiple records for the dimension then you don't get data, try using

=Ceil(Max(DateSent)-Max(DateReceived))

Hope it helps you.

Regards,

Jagan.

[jonathandienst]

What is the chart dimension? If the dates are not distinct per dimension line, you will to apply an aggregation function like Min() or Max().

[#6]

chart dimension is insurer.

I have 7 insurer.

[#7]

hi try this

=interval(num(DateSent)-num(DateReceived),'DD')