Date difference in separate field

[#1]

Hi,

I have two fields Date Sent and Received

I want the difference of two fields in an another field say "Difference"

i.e Date Sent - Date Received = Difference

So that i can use the difference field in another chart as an expression.

I want the difference as number of days.

I have attached the Date.qvw.

Thanks in advance,

Keerthi

[#2]

It comes in straight table. but i want the date difference for some other dimension

Ex: For UNDERWRITER.

I want it in a bar chart, with Underwriter as dimension and and average of date difference as expression.

Please help me with this

.

Regards,

Keerthi

[tresB · Accepted solution]

May be like attached sample?

PFA

[Anonymous]

Create the difference of dates in script instead at front end.

[#5]

Thanks a lot Tresesco