Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date today 18 months ago

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

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

You can use AddMonths function like

AddMonths(Today(), -18)

Celambarasan

View solution in original post

3 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

You can use AddMonths function like

AddMonths(Today(), -18)

Celambarasan

Not applicable
Author

Hi,

try sth like this

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

Hth
Roland

Anonymous
Not applicable
Author

Thanks a lot, such a simple solution