Sum with date difference

[Louveduval]

Hello,

I have many fields : N° of  order , costumer , order date , delevery date , ammount . 

I need to make : if delevery date - order date > 3 month then make the sum ammount for the N° of order else null . 

But I ve try to make if ((interval delevery date - order date ) >3 ),sum ammount ,0) 

but it's a big fail xD 

Can you help me ? 

[BrunPierre · Accepted solution]

Hi @Louveduval 

Perhaps something like this

=Sum(If((Year([DelIvery Date])-Year([Order Date]))*12+13-Month([Order Date])-(12-Month([DelIvery Date])) > 3, Amount, 0))

[Louveduval]

sadly it doesn't work

[BrunPierre]

You should provide a sample of data as well as the expected outcome.

[Louveduval]

It was a mistake form my part , I've used the bad filter  dd/MM/YYYY and not MM/YYYY