Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Partner
Partner

subtract months to a date/Restar meses a una fecha

hola

tengo una fecha ejemplo el día de hoy necesito restarle 11 meses pero no encuentro manera de hacerlo 

ya intente de varias maneras y no logro el resultado deseado

Hello

I have an example date today I need to subtract 11 months but I can't find a way to do it

I already tried in several ways and did not achieve the desired result

18/08/2019

MONTH(Timestamp(FECHA_APERTURA)-11)
Date(makedate(Month(FECHA_APERTURA)-11))
AddMonths(MonthsStart(FECHA_APERTURA),-11)

1 Solution

Accepted Solutions
Highlighted
Ezir
Contributor II

Re: subtract months to a date/Restar meses a una fecha

Hello @LUISDELVALLE ,

Maybe the problem is in the conversion... Try

AddMonths(Date('18/08/2019','DD/MM/YYYY'),-11)

 

Regards,

 

Ezir

1 Reply
Highlighted
Ezir
Contributor II

Re: subtract months to a date/Restar meses a una fecha

Hello @LUISDELVALLE ,

Maybe the problem is in the conversion... Try

AddMonths(Date('18/08/2019','DD/MM/YYYY'),-11)

 

Regards,

 

Ezir