Date comparison formula 1

[Hoppkins]

I have to create a formula to compare 2 dates.

The fields are date/time created and date/time completed. I need to count how many things were completed more than 5 days after they were created.

Without involving the time part how could this be done?

FOr previous functions on this report ive been using a crosstab to achieve the results.

Thankyou!

 

[lbass]

Try:

if datediff("d",{table.created},{table.completed}) > 5 then 1

Then insert a summary (SUM, not count) on this formula.

-LB

 

[Hoppkins]

Awesome thankyou that worked a treat.