topic Re: Most recent 8 months date function in QlikView

Most recent 8 months date function

Anonymous — Thu, 02 Nov 2017 14:29:34 GMT

I have a date field [Start Date], and I want to load only records with start date in the most recent 8 months, including current month. For example, for any date in November, I need to load records from Apr. 1st till Nov. 30th. I'm using this expression

"where [Start Date]>=AddMonths (monthend(today()), - 8);" in load script, but I got Mar. 31st loaded. Any idea why?

Thanks

Yvonne

Re: Most recent 8 months date function

vishsaggi — Thu, 02 Nov 2017 14:31:13 GMT

May be try like

WHERE [Start Date] > AddMonths (monthend(today()), - 😎

Re: Most recent 8 months date function

Anonymous — Thu, 02 Nov 2017 14:35:48 GMT

Still has Mar. 31...without "="

Re: Most recent 8 months date function

vishsaggi — Thu, 02 Nov 2017 14:36:12 GMT

Or try this?

Where [Start Date] >= MonthStart(AddMonths(MonthEnd(Today()), -7))

Here when you do MonthEnd of today you get 11/30/2017 and you are going back 8 months so it is going 30 Apr 2017. As Apr has 31 days when you do >= it pick up 31st too. So try the above expr and see.

Re: Most recent 8 months date function

vishsaggi — Thu, 02 Nov 2017 14:36:53 GMT

I just checked yes do not use that expr. Try the one which i posted just now.

Re: Most recent 8 months date function

Anonymous — Thu, 02 Nov 2017 14:43:36 GMT

Seems to work now. Thanks!