Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
hencovanee
Creator II
Creator II

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
Partner

Hi,

You can use AddMonths function like

AddMonths(Today(), -18)

Celambarasan

View solution in original post

3 Replies
CELAMBARASAN
Partner
Partner

Hi,

You can use AddMonths function like

AddMonths(Today(), -18)

Celambarasan

Not applicable

Hi,

try sth like this

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

Hth
Roland

hencovanee
Creator II
Creator II
Author

Thanks a lot, such a simple solution