Datetime doubt

[SahilArora3139]

Hi all

i want to ask how can i get no of days with one column only.

for example : i have scheduled date as:

2018-01-06

2018-01-07

2018-01-08

and i want to insert new column name: DAYSCOUNT

AND OUTPUT SHOULD BE 1 as there is only one day diff in all the dates. 

is it possible ?

please help

thank you

[ShankerV]

Hi @SahilArora3139 

Yes, please follow the below steps.

Use Multirow formula and datetimeadd function to get the desired output.

[ShankerV]

Hi @SahilArora3139 

One way of doing this.

datetimediff([Field1],[Row-1:Field1],"days")

Many thanks

Shanker V