shelf life

[riishabhz]

i have two columns of date 

a                                 b

13/7/2017           13/7/2018

i want to show shelf life as b-a = 365 

what should i do?

[Frank_Hartmann]

1:
LOAD * INLINE [
a, b
13/7/2017, 13/7/2018
];

NoConcatenate
2:
Load *, date#(b,'DD/MM/YYYY')-date#(a,'DD/MM/YYYY') as shelf Resident 1; DROP table 1;

[PrashantSangle · Accepted solution]

use
interval(b-a,'D')

Regards,

[riishabhz]

24-06-2017	24-06-2018	30/12/1900

interval(date#(B,'DD-MM-YYYY')-date#(A,'DD-MM-YYYY'),'D')

i tried your solution but now its not showing me as 365 output in 3rd column.

[PrashantSangle]

provided solution must work. can you describe what are the steps you are trying? where are you trying?

post your script and chart expression

Regards,

Prashant Sangle

[jonathandienst]

Remove the date format for the result column. 30/12/1900 is the date representation of the number 365.

[riishabhz]

yes it worked thanx