Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Solving the Informatica Dilemma: On-Demand Briefing - Watch On Demand!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator
‎2017-11-17 01:09 PM

Date Calulation

Hi

I have expiration date for each ID.

How can I calculate 18 months prior to that given date ?

Thank you.

738 Views
1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee
‎2017-11-17 01:16 PM

Addmonths(yourdate,-18)

View solution in original post

691 Views
1 Reply
Clever_Anjos
Employee
Employee
‎2017-11-17 01:16 PM

Addmonths(yourdate,-18)

692 Views