Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
CJMzMadrid
Partner - Contributor II
Partner - Contributor II

Fechas Qlik Sense

Buenos días, tengo un campo Fecha con el formato DD/MM/YYYY y necesito quedarme con fechas de 4meses hacia atrás desde la fecha actual. Alguna idea de como se puede hacer?

Un saludo y gracias

Labels (1)
3 Replies
JordyWegman
Partner - Master
Partner - Master

Hi,

Try this, it will add four months.

AddMonths([YourDateField],4)

Jordy

Climber 

Work smarter, not harder
CJMzMadrid
Partner - Contributor II
Partner - Contributor II
Author

Good morning,

the solution is incorrect.

I need to stay as of today with all dates 4 months ago maximum.

Thanks!!!

CJMzMadrid
Partner - Contributor II
Partner - Contributor II
Author

if([User Acces Last Used] < AddMonths(Today(),-3, [User Acces Last Used], -3))