Average Date Difference

[ajithsachin]

hi..

i have a table like this

code	date
01	01/04/12
01	08/04/12
01	19/04/12
02	01/04/12
03	02/04/12
04	10/04/12

i need the average date difference of each code

can anybody please help..

[#2]

avg(aggr(max(date)-min(date),code))

should do.

Kiran Rokkam.

[ajithsachin]

Thanks a lot..

[#4 · Accepted solution]

Mark the discussion to closure.

Kiran.