Calculate total days by a date field

[smilingjohn]

Hello All,

I have  to show a straight table with 4 columns ( Product,Stage1,Stage2 and Stage3) 

In this table I need to show the total number of days the product was .which should be calculated from one date field . 

This is how my data is like .  If you look at the data  for the product Milk  in Stage1  the date is 01-01-2021  and this product Milk moved to stage 2 on 23-02-2021  based on this we need to calculate the number of days  a product took to travel from one stage  to another . 

Date	Stage1	Stage2	Stage3
01-01-2021	Fruits	Chocolate	Rice
23-01-2021	Milk	Fruits	Chocolate
12-11-2021	Fish	Milk	Fruits

Thanks In advance 

[smilingjohn]

Hi All,

Any Help on above post ?

Thanks 

[smilingjohn]

This is how I want to show the output in a table  , Currently I am calculating manually  by I want to know is there way to make it load in script or can we use in an expression ?

Product	Stage1	Stage2	Stage3
Milk	323
Chocolate		22
Fruits	23	323
Rice

Thanks 

[smilingjohn]

Hi Community any help ?

Thanks