date

[fmazzarelli]

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

[brunobertels]

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]

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