topic Re: LastDateOfMonth in QlikView

LastDateOfMonth

Fri, 12 Apr 2013 14:03:23 GMT

Hello

I have to create a date spawn from 20000101 to last date in current year and month(period) 3

My result have to be: 20130331

I have year field and a period field to get data from, but i don't have the last date in the month (period)

I how can i assign this value to a variable "LastDateInPeriod)?

GunnarSchie

Re: LastDateOfMonth

Gysbert_Wassenaar — Fri, 12 Apr 2013 15:39:18 GMT

This should do the trick: monthend(makedate(MyYear, MyMonth)). Replace MyYear and MyMonth with your field names.

Re: LastDateOfMonth

Fri, 12 Apr 2013 17:39:44 GMT

Hallo Gysbert

Thank's for fast answer! How do I assign this to a variable?

Like this?

vMyLastdateofmonth = monthend (makedate (MyYear, MyMonth))

GunnarSchie

Re: LastDateOfMonth

Gysbert_Wassenaar — Sat, 13 Apr 2013 07:26:42 GMT

If you want to create the variable in the script you can use

SET vMyLastdateofMonth = monthend(makedate(MyYear, MyMonth));

You can also create the variable in the Variable Overview window by clicking on the Add button and entering a name for the variable. After you've created the variable select it in the Variables list and then enter the expression in the Definition box.

Remember to replace MyYear and MyMonth with the field names of your document.