Discussion Board for collaboration on QlikView Scripting.
I have a 'create_date' field and have to find if my create date is 30 months older than current date and also calculate how many days left until its 36 months old.How do I achieve that?
Go to Solution.
Today() > AddMonths(create_date,30) will return true (-1) if create_date is older than 30 months
AddMonths(create_date,36) - Today() will return number of days left until 36 months