Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Date Function

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?

1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: Date Function

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

1 Reply
nagaiank
Valued Contributor III

Re: Date Function

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

Community Browser