Create report with expression

[Gil]

Hi,

I need to create a report allowing me to obtain a list of customers who have made a purchase in the last 120 days.

I have tested a report with this option : 01.png
and is not working

and i have tested this configuration : 02.png
and is not working

how do I get the result I am looking for?

thanks in advance

regards

[DEN]

Hi,

Maybe this will help you:

https://docs.espocrm.com/user-guide/reports/#complex-expression

https://docs.espocrm.com/administration/formula/#datetime

[Gil]

Thanks for your help.

I used your links as well as the following post: https://forum.espocrm.com/forum/gene...on-not-working

now it works

thank you !!!