Date today 18 months ago

[Anonymous]

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

[CELAMBARASAN · Accepted solution]

Hi,

You can use AddMonths function like

AddMonths(Today(), -18)

Celambarasan

[#3]

Hi,

try sth like this

=AddMonths(today(),-12) returns "today of last year"

Hth
Roland

[Anonymous]

Thanks a lot, such a simple solution