Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

date

Hi Community,

may help me?

I'm using several extensions and I need to create a new dimension

Field: vbutton1

i use the function ..... DateAdd(Month,-4,getdate()) but probably is an incorrect statement

My needs is:

Today: 09/10/2015

Add 30 days

Next date: 09/11/2015

or

Today: 09/10/2015

Add  - 30 days

Next date: 09/09/2015

creating a new Dimension

Immagine.png

2 Replies
brunobertels
Valued Contributor

Re: date

Hi Fabio

May be you should use this :

+ 30 days :

date(today()+30,'DD/MM/YYYY')

-30 days :

date(today()-30,'DD/MM/YYYY')

Hope it helps

Bruno

kmarsden
New Contributor III

Re: date

Would one of these do what you need?

ADDMONTHS(TODAY(),1) //add months to your dates, can use negative numbers also

DATE(TODAY()+30) //add or subtract days to a date

Community Browser