topic Re: Previous MonthYear based on today in QlikView

Previous MonthYear based on today

kevbrown — Fri, 07 Jul 2017 10:44:08 GMT

Hi,

I'm looking to get a YearMonth field for the previous month based on todays date, this ideally needs to be TEXT. So for today I would like to 2017/06

Thanks

Kev

Anonymous — Fri, 07 Jul 2017 10:48:20 GMT

Hi,

Try:

date(addmonths(today(),-1),'YYYY/06')

Anonymous — Fri, 07 Jul 2017 10:49:16 GMT

date(addmonths(today(),-1),'YYYY/MM')

kevbrown — Fri, 07 Jul 2017 10:54:56 GMT

Perfect thanks