cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Akshaya Member
Member

Calclulating Days between 2 dates in the edit query

Hey,

 

Is there a way that I can calculate the number of days between 2 dates in the edit query option itself. The DatedIFf Formula does not work in the add custom columns. It says it cannot be recognized.

 

Is there any other syntax or formula that can be used? Thank You!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Calclulating Days between 2 dates in the edit query

@Akshaya

 

Try with following custom column

 

=Duration.Days(Duration.From([End]-[Start])))
1 REPLY 1
Super User
Super User

Re: Calclulating Days between 2 dates in the edit query

@Akshaya

 

Try with following custom column

 

=Duration.Days(Duration.From([End]-[Start])))