date difference

[sagarrahul]

	in i want
	current date subtract max date ie (current date - max date )
	after that when it output arrives if the differnce between date is 1 day ie
	eg (04-Feb-2016 - 03-Feb-2016) then i another column it should show difference as '1'and in another column its sholud its claim no difference
	and its max date in another coulmn  .

	CLM_INTIMATION_DATE	max date	claim no	current date
	28-Jan-2016	28-Jan-2016	RC-HS15-10335711	5/30/2016
	03-Feb-2016	03-Feb-2016	RC-HS15-10341139	5/30/2016
	08-Mar-2016	08-Mar-2016	RC-HS15-10343361	5/30/2016
	22-Mar-2016	22-Mar-2016	RC-HS15-10336529	5/30/2016
	08-Feb-2016	08-Feb-2016	RC-HS15-10336520	5/30/2016
	08-Feb-2016	08-Feb-2016	RC-HS15-10337526	5/30/2016
	15-Feb-2016	22-Mar-2016	RC-HS15-10343361	5/30/2016
	11-Feb-2016	12-Feb-2016	RR-HS15-10336940	5/30/2016
	11-Feb-2016	13-Feb-2016	RR-HS15-10336940	5/30/2016
		14-Feb-2016	RR-HS15-10341978	5/30/2016

	20-Jan-2016	20-Jan-2016	RR-HS15-10341246	5/30/2016
	09-Mar-2016	09-Mar-2016	RR-HS15-10341246	5/30/2016
	09-Mar-2016	07-Mar-2016	RR-HS15-10341246	5/30/2016

so pls help me in this as soon as possible

[sagarrahul]

i max dreamer this is whr i want in my output .

max date	claim no	current date		differnce (current date-max date)		clm num
28-Jan-2016	RC-HS15-10335711	5/30/2016		125		here dif is not 1 so it should be blank
29-May-2016	RC-HS15-10341139	5/30/2016		1		RC-HS15-10341139
08-Mar-2016	RC-HS15-10343361	5/30/2016		119		-
22-Mar-2016	RC-HS15-10336529	5/30/2016		85		-
08-Feb-2016	RC-HS15-10336520	5/30/2016		85		-
08-Feb-2016	RC-HS15-10337526	5/30/2016		71		-
29-May-2016	RC-HS15-10343361	5/30/2016		1		RC-HS15-10343361
12-Feb-2016	RR-HS15-10336940	5/30/2016		114
13-Feb-2016	RR-HS15-10336940	5/30/2016		114
14-Feb-2016	RR-HS15-10341978	5/30/2016		107
29-May-2016	RR-HS15-10341246	5/30/2016		1		RR-HS15-10341246
09-Mar-2016	RR-HS15-10341246	5/30/2016		71
07-Mar-2016	RR-HS15-10341246	5/30/2016		111

[PrashantSangle]

Hi,

For diff

interval(currentDate-maxDate)

for clum Num

if(interval(currentDate-maxDate)=1,claimNo)

Regards

[Peter_Cammaert]

Use this for column clm num:

IF (Interval(currentDate - maxDate, 'D') = 1, ClaimNo)

or to make your table independent from the currentDate column, use

IF (Interval(today() - maxDate, 'D') = 1, ClaimNo)

[sagarrahul]

ty bro it working fine

[sagarrahul]

ty bro it working fine

[PrashantSangle]

Hi,

If you got the correct answer then please close the thread.

Regards