Calculating the number of Days between two dates

[Folarin]

Hi

I need to calculate the Total number of days tasks have been open.

I have these 2 columns:

Date Created
Resolution Date

any help would be appreciated

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

Interval([Date Created]-[Resolution Date], 'DD')

[JordyWegman · Accepted solution]

Hi Folarin,

Use the following formula:

[Resolution Date] - [Date Created] 

If that doesn't work try:

floor([Resolution Date]​) - Floor([Date Created])

Jordy

Climber

[Folarin]

For some reason none of them are working.

what is the DD at the end of your expression?

[JordyWegman]

Hi Folarin,

What is the content of your fields? Can you show that?

'DD' stands for days so it would calculate the amount of days in the interval. This could also be 'MM' in Months.

Jordy

Climber

[Anil_Babu_Samineni · Accepted solution]

@Folarin Could be format issue with your rows.