Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
In our sales reports we would like to see all the customers who have no orders for the last 18 months. So, the expression I would like to use is: orderdate > date 18 months ago. The question is: how do I get the date of 18 months ago in my expression?
To make it simple: which date was it today, 18 months ago. How do I calculate that?
Kind regards,
Henco
Hi,
You can use AddMonths function like
AddMonths(Today(), -18)
Celambarasan
Hi,
You can use AddMonths function like
AddMonths(Today(), -18)
Celambarasan
Hi,
try sth like this
=AddMonths(today(),-12) returns "today of last year"
Hth
Roland
Thanks a lot, such a simple solution