Get SUM between two dates

[rsreyes]

Hi

I've two dates:
- DueDate

- Today

I want to know the number of days overdue

Any idea?

Thks

[Greg_Deckler]

I believe that is:

DATEDIFF([DueDate],[Today],day)

https://msdn.microsoft.com/en-us/library/dn802538.aspx

[Phil_Seamark]

For some weird reason, the DATEDIFF function returns an error when the number is negative (which it might be).

So you can patch that by doing = IFERROR(DATEDIFF([DueDate],[Today],day),-1)

Or try = [DueDate] - [Today] and format the column as int.