Comparing Current day record with previous day ??

[Silambarasan1306]

Hi All,

I have a table like below mentioned.

Date	Item
4/1/2016	A
4/1/2016	B
4/2/2016	B
4/2/2016	C
4/3/2016	C
4/3/2016	D
4/3/2016	E

on 1st april, A, B Items are available, On 2nd A item is not available. So, i need a status In Active. But new record C added on 2nd. So, for that i need a status Active. So, i need a final result below mentioned.

Date	Item	Status
4/1/2016	A
4/1/2016	B
4/2/2016	B	NotActive(A)
4/2/2016	C	Active
4/3/2016	C	NotActive(B)
4/3/2016	D	Active
4/3/2016	E	Active

Thank you

[sunny_talwar]

Are you envisioning this to be done in the script or front end of the application?

[Silambarasan1306]

Hi Sunny,

This to be done in the script itself.

Thank you

[sunny_talwar]

Just so I understand this better, if we had data like this... what would be the output?

Date	Item
4/1/2016	A
4/1/2016	B
4/1/2016	C
4/2/2016	B
4/2/2016	C
4/2/2016	D
4/2/2016	E
4/3/2016	E
4/4/2016	A
4/5/2016	B

[Silambarasan1306]

Hi Sunny,

find the below mentioned

Date	Active/InActive
4/1/2016	2
4/2/2016	1/1	C- Active, A -Inactive
4/3/2016	2/1	D,E - Active, B - InActive