topic Problems with Variable in QlikView

Problems with Variable

Thu, 23 Apr 2009 17:13:39 GMT

Why do I get a error on this one in QV 8.5 ? Anyone got some other idea of writing the first day of last month in the following date format 01-mar-2009?

LET ToMonth=left(date(monthstart(TODAY(),-1),'DD-MM-YYYY'),2) && '-' && month(date(monthstart(TODAY(),-1),'DD-MM-YYYY')) && '-' && right(date(monthstart(TODAY(),-1),'DD-MM-YYYY'),4)

Problems with Variable

Thu, 23 Apr 2009 17:27:46 GMT

I found the answer. So stupid! forgot the ;

Problems with Variable

Anonymous — Thu, 23 Apr 2009 18:24:10 GMT

Another way of getting the first day of the previous month compared to todays date is this:

LET ToMonth = monthstart(addmonths(Today(),-1));

Problems with Variable

Thu, 23 Apr 2009 19:10:22 GMT

Thanks!