date

[fmazzarelli]

Hi Community,

i'm adding a new measure called 30 DAYS but unfortunately it doesn't work

Could you help me?

[fmazzarelli]

ops,

Month(date(today(),'DD/MM/YYYY'))

[maxgro]

maybe

=if([Data Documento] <= Today() and [Data Documento]>=AddMonths(Today(),-1), 30, 0)

[fmazzarelli]

and

if ([Data Documento]<= today() and [Data Documento]>= AddMonths(today(),-1),30,0)

How is the statement correct?

[fmazzarelli]

if ([Data Documento]< (DateAdd(day, -1, AddMonth(today(),-4))), 'OLTRE 120',0)